Duh mas yanu ini jangan2 ngetest saya doang yaaa jadi malu...
Yanu Widodo wrote:
he3x,
saya tadi salah ketik.
mysql> load data infile "/tmp/sql/coba.sql"
-> into table coba
-> LINES TERMINATED BY ','
-> ENCLOSED BY '"';
yng benar seharusnya ...
mysql> load data infile "/tmp/sql/coba.sql"
-> into table coba
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"';
btw, thanks, mas leo telah
bantu membukakan pintu
--
yanu
On Thu, 2006-05-18 at 15:14, Leo B. wrote:
Kalau masih error saya juga bingung, karena menurut primbon ya begitu
syntaxnya. Mungkin sekarang saat yang tepat untuk menggunakan phpmyadmin :P
Coba deh, text-nya dibawa ke phpmyadmin untuk di import, kalau sukses
scriptnya akan kelihatan dilayar, terus coba copy paste dan jalankan
script tsb. mudah-mudahan jalan. Yang lain mungkin ada yang bisa bantu?
Yanu Widodo wrote:
Sama mas leo,
mysql> load data infile "/tmp/sql/coba.sql"
-> into table coba
-> LINES TERMINATED BY ','
-> OPTIONALLY ENCLOSED BY '"';
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'OPTIONALLY ENCLOSED BY '"'' at line 4
mysql> load data infile "/tmp/sql/coba.sql"
-> into table coba
-> LINES TERMINATED BY ','
-> ENCLOSED BY '"';
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ENCLOSED BY
'"'' at line 4
trims
--
yanu
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:
--
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