Re: [tanya-jawab] Masalah nge-Load Data ke Table
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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
coba gunakan phpmyadmin. pakai fungsi import from text file. biasanya, kalo format seragam, dia akan langsung mendeteksi dan diinputkan ke mysql. selamat nyoba Slamet siang fren, Misalnya ada data dalam file coba.txt isinya : ---start coba.txt 2005-05-01OK 2005-05-01OK 2005-05-01OK 2005-05-01OK 2005-05-01OK 2005-05-01OK -- -- 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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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-02OK 2005-05-03OK 2005-05-04OK 2005-05-05OK 2005-05-06OK -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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
Ok, Bravo mas leo, sukses. --snip2 | 2006-05-01 | OK | | 2006-05-02 | OK | | 2006-05-03 | OK | +++ 47 rows in set (0.00 sec) trims banget yah !! -- yanu On Thu, 2006-05-18 at 14:31, Leo B. wrote: 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-02OK 2005-05-03OK 2005-05-04OK 2005-05-05OK 2005-05-06OK -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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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
Re: [tanya-jawab] Masalah nge-Load Data ke Table
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