SH> ternyata mysql bisa import csv (maafkan posting saya
SH> sebelumnya). tapi, perintah di bawah kurang klausa
SH> optionally enclosed by '"'
SH> escaped by '\\'
Kurang klausanya di mana stev ?
aku udah coba kayaknya bisa
SH> jadi sintaks lengkapnya:
SH> load data infile 'FOO.csv' into table BAR
SH> fields terminated by ','
SH> optionally enclosed by '"'
SH> escaped by "\\"
SH> lines terminated by "\n";
kelebihan dari cmd diatas ?
makasi masukannya
SH> --
SH> sh
SH> At 13:16 25/09/00, you wrote:
>>coba :
>>-------------
>>mysql> load data infile "data.csv" into table member fields terminated by
>>"," lines terminated by "\n";
>>-------------
>>
>>untuk lebih lengkapnya lihat di manual mysql /usr/doc/MySQL*
>>di situ ada penjelasan lengkapnya.
>>
>>On Sat, 23 Sep 2000, MailList wrote:
>>
>> > From: MailList <[EMAIL PROTECTED]>
>> > To: Linux Progrmming <[EMAIL PROTECTED]>
>> > Reply-To: [EMAIL PROTECTED]
>> > Subject: [programming] Import data ke Mysql
>> > Date: Sat, 23 Sep 2000 10:30:41 +0700
>> > X-Mailer: The Bat! (v1.41) UNREG / CD5BF9353B3B7091
>> >
>> > Milis,
>> >
>> > Aku mau import data dari file csv ke mysql
>> > aku udah coba pake
>> > mysql>load data infile "data.csv" into table member;
>> >
>> > tapi hasilnya berantakan, sumua muncul dalam satu field
>> >
>> > mohon masukan dari milis
>> >
>> >
>> > makasih sebelumnya
>> > --
>> > Salam;
>> > Ptr
>> >
>> >
>> >
>> >
>> --------------------------------------------------------------------------------
>> > Utk berhenti langganan, kirim email ke
>> [EMAIL PROTECTED]
>> > Informasi arsip di http://www.linux.or.id/milis.php3
>> > Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
>> >
>>
>>--
>>Salam
>>Yohanes
>>
>>SMS Mail : [EMAIL PROTECTED]
>>http://langitbiru.hypermart.net
SH> --------------------------------------------------------------------------------
SH> Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
SH> Informasi arsip di http://www.linux.or.id/milis.php3
SH> Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
--
Best regards,
prt
--------------------------------------------------------------------------------
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
