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

Article View: cn.bbs.comp.database

Article #1575

Back to cn.bbs.comp.database Previous Next

#1575

From: yihua
Date: Tue, 05 Dec 2006 01:52

16 lines
1296 bytes

лл��������mysql�Դ��mysqlimport,ò��������
�� �� liuliu (��������w�R��) �Ĵ������ᵽ: ��
: 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]
: .................������ʡ�ԣ�
--

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

Technical Details

Message-ID: <4RObJ2$bOg@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsgate.cuhk.edu.hk!news.szu.edu.cn!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!news4.google.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsgate.cuhk.edu.hk!news.szu.edu.cn!bbsnews.sdu.edu.cn!SJTUBBS
From: Yihua.bbs@bbs.sjtu.edu.cn (yihua)
Newsgroups: cn.bbs.comp.database
Subject: Re: ������ν�csv�ı����ݵ���mysql�У�
Date: 05 Dec 2006 01:52:09 GMT
Organization: ��ˮ˼Դ
Message-ID: <4RObJ2$bOg@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1165283474.A

Article View: cn.bbs.comp.database

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

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