ternyata mysql bisa import csv (maafkan posting saya
sebelumnya). tapi, perintah di bawah kurang klausa
optionally enclosed by '"'
escaped by '\\'
jadi sintaks lengkapnya:
load data infile 'FOO.csv' into table BAR
fields terminated by ','
optionally enclosed by '"'
escaped by "\\"
lines terminated by "\n";
--
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
--------------------------------------------------------------------------------
Utk berhenti langganan, kirim email ke [EMAIL PROTECTED]
Informasi arsip di http://www.linux.or.id/milis.php3
Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
