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]
