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