Arsip: import txt ke mysql

more 13 years ago
mrajex
Mo nanya import *.txt ke mysql
code yg ane buat sperti ini
format .txt
kode jml1 jml2 tgl jam
01 2 3
LOAD DATA INFILE 'D:\\barcode\\01.txt' INTO TABLE pjjx FIELDS TERMINATED BY ',';
sebenernya sih data sudah masuk di table pjjx...tp di mysql kok muncul pesen error ya...
data truncate for column 'jml1' at row 1
data truncate for column 'jml2' at row 1
berulang seperti diatas sesuai jmlh record...
tp data sudah masuk dan benar,minta pencerahannya mas mas...
more 13 years ago
elva_ivana
setahu saya.... kalau dilihat dari bunyi error nya, itu menandakan kolom tsb not allow null
coba periksa antara data d file txt sama skema tabel...

more 13 years ago
mrajex
jadi gini data di txt:
01 ,1 ,2 ,2011/05/14,10:03:43
02 ,30 ,24 ,2011/05/14,10:03:43
nah klo pas delimeter atra tanggal ma jam gak ada masalah....
jd untuk mngatasi hal tersebut gmna ya?

more 13 years ago
mrajex
Data .txt kaya gini :
000000217801 ,0 ,50 ,2011/02/01,10:03:43
000000172201 ,0 ,20 ,2011/02/01,10:04:26
000000247801 ,1 ,76 ,2011/02/01,10:06:38
000000547101 ,2 ,200 ,2011/02/01,10:07:53
000000031102 ,0 ,20 ,2011/02/01,10:08:24
000000186901 ,0 ,50 ,2011/02/01,10:09:04
000000005202 ,0 ,50 ,2011/02/01,10:09:34
000000219001 ,0 ,20 ,2011/02/01,10:09:56
000000058901 ,0 ,100 ,2011/02/01,10:11:36
Strurtur Tabel
CREATE TABLE pjjx (
kode char(12) NOT NULL default '',
jml1 double NOT NULL default '0',
jml2 double NOT NULL default '0',
tanggal date NOT NULL default '0000-00-00',
jam time NOT NULL default '00:00:00'
) ENGINE=MyISAM;
Mohon pencerahan agar kolom jml1 dan jml2 masuk di table tanpa pesan error...(konversi string ke double)...
more 13 years ago
elva_ivana
setelah saya edit file *.txt (tanpa spasi) menjadi

000000217801,0,50,2011/02/01,10:03:43
000000172201,0,20,2011/02/01,10:04:26
000000247801,1,76,2011/02/01,10:06:38
000000547101,2,200,2011/02/01,10:07:53
000000031102,0,20,2011/02/01,10:08:24
000000186901,0,50,2011/02/01,10:09:04
000000005202,0,50,2011/02/01,10:09:34
000000219001,0,20,2011/02/01,10:09:56
000000058901,0,100,2011/02/01,10:11:36
dengan script query yang sama, dan hasilnya adalah :


more 13 years ago
mrajex
Bang Kalo misal data itu ada sepasinya.....soalnya hasil dari alat uda kaya gt dan datanya banyak....trs type data double....
utk code program kaya mana ya,biar gak mncul message data truncate for column.

more 13 years ago
elva_ivana
berarti harus ada filter agar spasi tidak muncul...
banyak cara, salah satunya file text di edit sebelum insert ke database
more ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- Menampilkan image
by coolmib in Multimedia & Graphic Enhancement more 18 years ago - Masalah Uses Clause
by ciedelphier in Hal umum tentang Pascal Indonesia more 15 years ago - delphi 6 update 2
by wati in OOT more 13 years ago - Track mouse buat remote admin
by mcrayeps in Form Enhancement & Graphical Controls more 17 years ago - suara pada headset di atur outputnya left & right
by gormet in Enginering more 18 years ago - Pemrogramman Delphi Untuk Net
by Eddy_SG in Network, Files, I/O & System more 18 years ago - Ask table exist di zeos
by ferry in Lain-lain more 16 years ago - Test your logic - QUIZ -
by ZeAL in OOT more 19 years ago - artikel
by _aa_ in Network, Files, I/O & System more 19 years ago - Kapan Delphi-ID bisa seperti ini ?
by Manz in Hal umum tentang Pascal Indonesia more 15 years ago