Re: ��ν�csv�ı��ݵ��mysql�У�

Article View: cn.bbs.comp.database

Article #1572

Back to cn.bbs.comp.database Previous Next

#1572

From: ��w�R��
Date: Sat, 02 Dec 2006 16:15

17 lines
1184 bytes

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [FIELDS
        [TERMINATED BY '\t']
        [[OPTIONALLY] ENCLOSED BY '']
        [ESCAPED BY '\\' ]
    ]
    [LINES TERMINATED BY '\n']
    [IGNORE number LINES]
    [(col_name,...)]

�� �� Yihua (yihua) �Ĵ������ᵽ: ��
: лл
--

[m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.196.167.42][m

Technical Details

Message-ID: <4RMhJ2$aqX@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news2.happynet.org!bbsnews.sdu.edu.cn!SJTUBBS

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,e61aa6d441702998
X-Google-Attributes: gid101948,public
X-Google-Language: ENGLISH,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news2.happynet.org!bbsnews.sdu.edu.cn!SJTUBBS
From: liuliu.bbs@bbs.sjtu.edu.cn (��������w�R��)
Newsgroups: cn.bbs.comp.database
Subject: Re: ������ν�csv�ı����ݵ���mysql�У�
Date: 02 Dec 2006 16:15:27 GMT
Organization: ��ˮ˼Դ
Message-ID: <4RMhJ2$aqX@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1165076114.A

Article View: cn.bbs.comp.database

Re: ������ν�csv�ı����ݵ���mysql�У�

Re: ��ν�csv�ı��ݵ��mysql�У�