Ok, Bravo mas leo, sukses.
--snip2---- | 2006-05-01 | OK | | 2006-05-02 | OK | | 2006-05-03 | OK | +------------+--------+ 47 rows in set (0.00 sec) trims banget yah !! -- yanu On Thu, 2006-05-18 at 14:31, Leo B. wrote: > LOAD DATA INFILE coba.txt > INTO TABLE coba -> FIELDS TERMINATED BY ',' > OPTIONALLY ENCLOSED BY '"'; > > Yanu Widodo wrote: > > He3x, oke mas leo ... > > trims banget yah > > > > sudah bisa masuk nih :) > > > > namun masih sedikit masalah, yg masuk cuma karakter <"> dan <O> > > > > ---snip2----- > > > > | 2006-05-01 | | > > | 2006-05-02 | | > > | 2006-05-03 | | > > | 2006-05-01 | "O | > > | 2006-05-02 | "O | > > | 2006-05-03 | "O | > > +------------+--------+ > > 28 rows in set (0.00 sec) > > > > > > ada saran lagi ?! > > > > > > trims, > > > > > > --- > > yanu > > > > On Thu, 2006-05-18 at 13:36, Leo B. wrote: > > > >> LOAD DATA INFILE coba.txt > >> INTO TABLE coba -> FIELDS TERMINATED BY ','; > >> > >> Yanu Widodo wrote: > >> > >>> Sory kepencet .... > >>> ------------ > >>> > >>> Misalnya ada data dalam file coba.txt > >>> isinya : > >>> > >>> ---start coba.txt---- > >>> 2005-05-01 OK > >>> 2005-05-02 OK > >>> 2005-05-03 OK > >>> 2005-05-04 OK > >>> 2005-05-05 OK > >>> 2005-05-06 OK > >>> -----eof------------ > >>> > >>> ternyata bisa dimasukkan ke dalam table (dua kolom saja) > >>> dengan command : > >>> > >>> mysql> load data infile "/tmp/sql/coba.txt" > >>> -> into table coba; > >>> > >>> > >>> kalau datanya dipisahkan dengan koma: > >>> > >>> ---start coba.txt---- > >>> "2005-05-01","OK" > >>> "2005-05-02","OK" > >>> "2005-05-03","OK" > >>> "2005-05-04","OK" > >>> "2005-05-05","OK" > >>> "2005-05-06","OK" > >>> -----eof------------ > >>> > >>> > >>> adakah teman2 yg punya ide ?! > >>> > >>> > >>> > >>> trims > >>> > >>> > >>> > >>> -- > >>> yanu > >>> > >>> > >>> > >>> > >>> > >>> > >>> > > > > > > > -- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke [EMAIL PROTECTED] Arsip dan info milis selengkapnya di http://linux.or.id/milis
