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
On Thu, 2006-05-18 at 14:29, Leo B. wrote:
> 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
