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
