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
