waduh tiba-tiba migrain sayah... he3x.
Saran saya sih di bersihin dulu kali ya tanda kutipnya dibuang semua.
Jadi di edit dulu file textnya. Terus jalankan sintaks yang pertama tadi.
Atau silahkan experiment pakai syntax selengkapnya: (kalau berhasil
posting disini ya, saya juga mau)
---------------------
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE '/|file_name|/.txt'
[REPLACE | IGNORE]
INTO TABLE /|tbl_name|/
[FIELDS
[TERMINATED BY '/|string|/']
[[OPTIONALLY] ENCLOSED BY '/|char|/']
[ESCAPED BY '/|char|/' ]
]
[LINES
[STARTING BY '/|string|/']
[TERMINATED BY '/|string|/']
]
[IGNORE /|number|//|col_name_or_user_var|/,...)]
[SET /|col_name|/ = /|expr|/,...)] LINES]
[(/|col_name_or_user_var|/,...)]
[SET /|col_name|/ = /|expr|/,...)]
---------------
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
