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
