一些SQL操作语句(2)
返回
<![CDATA[
Please input database table name=quo2
DBD::mysql::db do failed: Incorrect integer value: '' for column 'disc0' at row
1 at insert_tables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("4030",
"2009-06-12","1","8","1","15D","2","120","100","120=120=120=120=120=120=120=120=
120=120=120=120=120=120=120=120=120=120=120=120=120=120","","D","33.60=22.20=22.
20=111.00=22.20=16.80=277.80=200.40=33.60=27.60=22.20=222.00=16.80=544.80=22.20=
22.20=27.60=0.00=0.00=0.00=33.60=50.40=0.00=0.00=0.00","","","","100","D0")
DBD::mysql::db do failed: Incorrect integer value: '=100' for column 'disc0' at
row 1 at insert_tables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("4189",
"2009-06-18","1","1","1","15D","1","20000","100","20000=20000=20000=20000=20000=
20000=20000=20000=20000=20000","D","840=2800=2800=60=2000=0=20000=11000=11000","
","","","=100","D0","4.2=14=14=0.3=400=0=20000=8000=8000=")
quo2===4030===2009-06-12===1===8===1===15D===2===120===100===120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120======D===33.60=22.20=22.20=111.00=22.20=16.80=277.80=200.40=33.60=27.60=22.20=222.00=16.80=544.80=22.20=22.20=27.60=0.00=0.00=0.00=33.60=50.40=0.00=0.00=0.00============100===D0===28.00=18.50=18.50=92.50=18.50=14.00=231.50=167.00=28.00=23.00=18.50=185.00=14.00=454.00=18.50=18.50=23.00=0=0=0=28=42=0=0=4.5
quo2===4030===2009-06-12===1===8===1===15D===2===120===100===120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120=120===D===33.60=22.20=22.20=111.00=22.20=16.80=277.80=200.40=33.60=27.60=22.20=222.00=16.80=544.80=22.20=22.20=27.60=0.00=0.00=0.00=33.60=50.40=0.00=0.00=0.00============100===D0===28.00=18.50=18.50=92.50=18.50=14.00=231.50=167.00=28.00=23.00=18.50=185.00=14.00=454.00=18.50=18.50=23.00=0=0=0=28=42=0=0=4.5
D前面的======改为===
quo2===4189===2009-06-18===1===1===1===15D===1===20000===100===20000=20000=20000=20000=20000=20000=20000=20000=20000=20000===D===840=2800=2800=60=2000=0=20000=11000=11000=============100===D0===4.2=14=14=0.3=400=0=20000=8000=8000=
quo2===4189===2009-06-18===1===1===1===15D===1===20000===100===20000=20000=20000=20000=20000=20000=20000=20000=20000=20000===D===840=2800=2800=60=2000=0=20000=11000=11000============100===D0===4.2=14=14=0.3=400=0=20000=8000=8000=
100===D0前面的=减少一个
]]>
<![CDATA[
DBD::mysql::db do failed: Incorrect integer value: 'C' for column 'LANGUAGEid' at row 1 at insert_tables.pl line 65.
INSERT INTO enq1 (id,time,ourref,owner,ownerno,hullnoid,type1id,partsid,QTY,memo,LANGUAGEid,makerid,enq2s,seriesid) VALUES("3322","2009-04-06","9040608","11","09-04-06","416","708==709","55==29=30=31=32=33=34=35=36=37=38=39=40=41","","","C","3==6=3=6=3=3=3=3=5=5=6=6=3=3","","1")
enq1===3322===2009-04-06===9040608===11===09-04-06===416===708==709===55==29=30=31=32=33=34=35=36=37=38=39=40=41=========C===3==6=3=6=3=3=3=3=5=5=6=6=3=3======1===1===3722===C
enq1===3322===2009-04-06===9040608===11======1===B===C===C======1===1===834===C
解决方法
partsid: 55==29=30=31=32=33=34=35=36=37=38=39=40=41=========C
UPDATE enq1 SET partsid = "55==29=30=31=32=33=34=35=36=37=38=39=40=41" WHERE id = 3322;
DBD::mysql::db do failed: Incorrect integer value: '' for column 'disc0' at row
1 at insert_tables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("3159",
"2009-04-02","3","1","1","20D","1","15000","100","15000=15000=15000=15000=15000=
15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15
000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=1500
0=15000","","==100","100=100","D","75=30=1575=150=225=30=30=600=30=30=600=600=75
=30=150=150=60=60=525=30=375=30=30=30=30=30=30=17250=5325=1575=1575=8625=0=0=0=0
=0=0=0=0=24900=0=0=9900=88500","","","")
===>9900=88500后面加100
quo2===3159===2009-04-02===3===1===1===20D===1===15000===100===15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000========100===100=100===D===75=30=1575=150=225=30=30=600=30=30=600=600=75=30=150=150=60=60=525=30=375=30=30=30=30=30=30=17250=5325=1575=1575=8625=0=0=0=0=0=0=0=0=24900=0=0=9900=88500============100===D0===0.50 =0.20 =10.50 =1.00 =1.50 =0.20 =0.20 =4.00 =0.20 =0.20 =4.00 =4.00 =0.50 =0.20 =1.00 =1.00 =0.40 =0.40 =3.50 =0.20 =2.50 =0.20 =0.20 =0.20 =0.20 =0.20 =0.20 =115.00 =35.50 =10.50 =10.50 =57.50 =========24900===9900=88500
quo2===3159===2009-04-02===3===1===1===20D===1===15000===100===15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000========100===100=100===D===75=30=1575=150=225=30=30=600=30=30=600=600=75=30=150=150=60=60=525=30=375=30=30=30=30=30=30=17250=5325=1575=1575=8625=0=0=0=0=0=0=0=0=24900=0=0=9900=88500===100=========100===D0===0.50 =0.20 =10.50 =1.00 =1.50 =0.20 =0.20 =4.00 =0.20 =0.20 =4.00 =4.00 =0.50 =0.20 =1.00 =1.00 =0.40 =0.40 =3.50 =0.20 =2.50 =0.20 =0.20 =0.20 =0.20 =0.20 =0.20 =115.00 =35.50 =10.50 =10.50 =57.50 ======100===24900===9900=88500
DBD::mysql::db do failed: Incorrect integer value: 'NOTE: ITEM 2 INCLUDES 3,4,5'
for column 'disc0' at row 1 at insert_tables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("3218",
"2009-03-27","1","1","1","30D","1","120","100","120=120=120=120=120","D","324000
=63000","","","","NOTE: ITEM 2 INCLUDES 3,4,5","100","D0")
quo2===3218===2009-03-27===1===1===1===30D===1===120===100===120=120=120=120=120===D===324000=63000============NOTE: ITEM 2 INCLUDES 3,4,5===100===D0===180000=35000===
quo2===3218===2009-03-27===1===1===1===30D===1===120===100===120=120=120=120=120===D===324000=63000===NOTE: ITEM 2 INCLUDES 3,4,5===100===D0===100
===>D0后面加100
]]>
<![CDATA[
orderid=3033,2009-03-20,9030903
两个ORDER的EXCEL文件均能生成。Server的问题在哪儿?
seriesid的改造完成。第一次输入TYPE时同时可输入SERIES。
用户要:K8FE3VZS-W10
定购了:K8FE2VZ-W10-X
深刻的教训!价格输入的地方放上TYPE等!
ERROR,1948,==>,TEST,a001882
注意数据库同名的TEST修改!
ERROR,2127,==>,GHA150-2FLMH,a002126
注意数据库同名的大写,小写修改!
DBD::mysql::db do failed: Incorrect integer value: 'NOTE: ITEM 2 INCLUDES 3,4,5'
for column 'disc0' at row 1 at insert_tables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("3218",
"2009-03-27","1","1","1","30D","1","120","100","120=120=120=120=120","D","324000
=63000","","","","NOTE: ITEM 2 INCLUDES 3,4,5","100","D0")
","改成全角"，"
DBD::mysql::db do failed: Incorrect integer value: 'NOTE: ITEM 2 INCLUDES 3・・
・・' for column 'disc0' at row 1 at insert_tables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("3218",
"2009-03-27","1","1","1","30D","1","120","100","120=120=120=120=120","D","324000
=63000","","","","NOTE: ITEM 2 INCLUDES 3・・・・","100","D0")
"NOTE: ITEM 2 INCLUDES 3,4,5"==>disc0,不对!
quo2===3218===2009-03-27===1===1===1===30D===1===120===100===120=120=120=120=120===D===324000=63000============NOTE: ITEM 2 INCLUDES 3,4,5===100===D0===180000=35000===
quo2===3218===2009-03-27===1===1===1===30D===1===120===100===120=120=120=120=120===D===324000=63000===NOTE: ITEM 2 INCLUDES 3,4,5===100===D0
Please input database table name=quo2
DBD::mysql::db do failed: Data truncated for column 'disc0' at row 1 at insert_t
ables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("3218",
"2009-03-27","1","1","1","30D","1","120","100","120=120=120=120=120","D","324000
=63000","NOTE: ITEM 2 INCLUDES 3,4,5","100","D0","180000=35000","","")
OK!!!
quo2===3218===2009-03-27===1===1===1===30D===1===120===100===120=120=120=120=120===D===324000=63000=========NOTE: ITEM 2 INCLUDES 3,4,5===100===D0===180000=35000
注意:这个enq1id=0,需要操作一下修改。
enq2===3194===2009-02-23===0===1===1===1===1===101======418==1996==1997==1998=======4==4=======12==24======10000=15660===D===100===1===P1=========
enq2===3194===2009-02-23===0===1===1===1===1===218======B============P===D===100===1===P1=========
]]>
<![CDATA[
Please input database table name=enq1
DBD::mysql::db do failed: Incorrect integer value: '' for column 'LANGUAGEid' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq1 (id,time,ourref,owner,ownerno,hullnoid,type1id,partsid,QTY,memo,LANGUAGEid,makerid,enq2s,seriesid)
VALUES("2752","2009-02-14","9021409","1","SA-2P-AAA022","269","1161","7","","==1=1=1=1=2=8","","1","1","3086")
enq1===2752===2009-02-14===9021409===1===SA-2P-AAA022===269===1161===7========1=1=1=1=2=8======1===1===3086===C
enq1===2752===2009-02-14===9021409===1===SA-2P-AAA022===269===1161===7===1=1=1=1=2=8======1===1===3086===C
Please input database table name=enq2
DBD::mysql::db do failed: Incorrect integer value: '' for column 'discount0' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq2 (id,time,enq1id,LANGUAGEid,ORIGINid,PRICEid,PAYMENTid,makerid,DELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,disc,charges)
VALUES("2879","2009-02-06","2568","2","1","1","1","218","","273==276==1866==1867==1868==574==472","103=125=104=146=108=18=168=169=2=93=4=94=122=96=95=170=171==67==1==1=2==1==10==29=30=31=32=33=34=35=36=37=38=39=40=41=42","","","","","","","4==4==2=6","=1","","")
enq2===2879===2009-02-06===2568===2===1===1===1===218======273==276==1866==1867==1868==574==472===103=125=104=146=108=18=168=169=2=93=4=94=122=96=95=170=171==67==1==1=2==1==10==29=30=31=32=33=34=35=36=37=38=39=40=41=42=====================4==4==2=6====1=====================38.60 =58.00 =48.30 =1.40 =48.30 =0.30 =0.30 =0.30 =14.50 =0.80 =0.80 =5.30 =4.50 =9.70 =14.50 =5.80 =58.00 =145.00 =2.00 =48.30 =4.80 =116.00 =77.30 =580.00 =309.00 =338.00 =309.00 =125.60 =10.60 =9.70 =7.70 =9.70 =19.30 =19.30 =19.30 =19.30 =7.70 ===D===100===2===P1===AMT0901-0402======
enq2===2879===2009-02-06===2568===1===1===1===1===218======B============P===D===100===1===P1=========
]]>
<![CDATA[
mysql> select * from enq1 where type1id like "%639%"\G
mysql> update main_type1 set name="reserved1" where id = 447;
Query OK, 1 row affected (0.09 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from main_type1 where id = 519\G
*************************** 1. row ***************************
id: 519
name:
series: XXXSERIES
gname_id:
maker_id:
GR:
DWG: XXXDWG
memo:
1 row in set (0.00 sec)
mysql> update main_type1 set name="reserved2" where id = 519;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
]]>
部分表格的中间保存结果
<![CDATA[
enq1===781===2008-08-01===8080103===58======1===B===C===C======1===1===834===C
enq1===798===2008-08-02===8080217===36======1===B===C===C======1===1===852===C
enq1===798===2008-08-02===8080217===36===7-31 E-MAIL===466===954==955==956==957==958==959==960==961==667===1=2==1=2=3=4=5=6=7=8=9==1=2=3=4=5=6=7=8=9==1=2=3=4=5=6=7=8=9==1=2=3=4=5=6=7==1=2=3=4=5=6=7=8=9=10=11=12=13=14=15=16=17=18=19==1=2=3=4=5=6=7=8=9=10=11=12=13=14=15=16=17=18=19=20=21===2=1=4=3=12=13=5=11=9=6=7=8=10==8==========C==C===7=8==3=1=1=1=1=2=1=1=1==15=15=15=20=20=20=15=25=15==10=10=15=20=20=20=15=20=12==10=10=10=10=10=10=10==1=1=1=1=2=5=5=5=5=5=10=2=2=2=2=5=5=5=5==5=5=5=5=5=5=5=5=5=5=5=5=5=5=5=5=1=1=1=1=1===1=1=1=1=2=5=5=5=5=5=2=1=1==1============C======1===1===852===C
obtain_table1.pl==>enq1_798.txt
enq1===798===2008-08-02===8080217===36===7-31 E-MAIL===466===954==955==956==957==958==959==960==961==667===1=2==7=2=3=8=4=6=1=5=9==6=4=3=2=1=5=9=8=7==6=4=3=2=1=5=9=8=7==7=1=2=3=4=5=6==15=2=1=4=3=5=14=9=16=17=18=6=19=7=8=10=12=13=11==17=18=20=19=21=9=3=12=1=2=4=13=14=5=6=15=7=8=16=10=11==2=1=4=3=5==3=1=2===1=1==1=1=1=1=1=1=1=1=1==1=1=1=1=1=1=1=1=1==1=1=1=1=1=1=1=1=1==1=1=1=1=1=1=1==1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1==1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1==1=1=1=1=1==1=1=1======1===1===852===C
mysql> select * from enq1 where id = 798\G
*************************** 1. row ***************************
id: 798
time: 2008-08-02
ourref: 8080217
owner: 36
ownerno: 7-31 E-MAIL
hullnoid: 466
type1id: 954==955==956==957==958==959==960==961==667
partsid: 1=2==7=2=3=8=4=6=1=5=9==6=4=3=2=1=5=9=8=7==6=4=3=2=1=5=9=8=7==7=1=2=
3=4=5=6==15=2=1=4=3=5=14=9=16=17=18=6=19=7=8=10=12=13=11==17=18=20=19=21=9=3=12=
1=2=4=13=14=5=6=15=7=8=16=10=11==2=1=4=3=5==3=1=2
QTY: 1=1==1=1=1=1=1=1=1=1=1==1=1=1=1=1=1=1=1=1==1=1=1=1=1=1=1=1=1==1=1=1=
1=1=1=1==1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1==1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=1=
1=1=1=1=1==1=1=1=1=1==1=1=1
memo:
LANGUAGEid: 1
makerid: 1
enq2s: 852
seriesid: C
1 row in set (0.00 sec)
]]>
<![CDATA[
enq2===40===2008-05-28===40===1===1===1===1===1======B============P===D===100===1===P1=========
enq2===732===2008-07-28===689===1===1===1===1===153======B============P===D===100===1===P1=========
enq2===732===2008-07-28===689===1===1===1===1===153======765===2=3=4=5=6=7===1=1=1=1=1=1======17000=110000=23000=11000=5000=1600==========100===1===P1=========
obtain_table1.pl==>enq2_732.txt(Discount,Discount0(数字)等的对位问题)
enq2===732===2008-08-15===689===1===1===1===1===153======765===2=3=4=5=6=7===1=1=1=1=1=1======17000=110000=23000=11000=5000=1600===D===100===1===P1=========
mysql> select * from enq2 where id = 732\G
*************************** 1. row ***************************
id: 732
time: 2008-08-15
enq1id: 689
LANGUAGEid: 1
ORIGINid: 1
PRICEid: 1
PAYMENTid: 1
makerid: 153
DELIVERY:
type1id: 765
partsid: 2=3=4=5=6=7
QTY: 1=1=1=1=1=1
memo:
price: 17000=110000=23000=11000=5000=1600
discount: D
discount0: 100
money: 1
price1: P1
makerref:
disc:
charges:
1 row in set (0.00 sec)
]]>
<![CDATA[
enq2===852===2008-08-02===798===1===1===1===1===1======954==955==956==957==958==959==960==961==667===1=2==1=2=3=4=5=6=7=8=9==1=2=3=4=5=6=7=8=9==1=2=3=4=5=6=7=8=9==1=2=3=4=5=6=7==1=2=3=4=5=6=7=8=9=10=11=12=13=14=15=16=17=18=19==1=2=3=4=5=6=7=8=9=10=11=12=13=14=15=16=17=18=19=20=21===2=1=4=3=12=13=5=11=9=6=7=8=10==8==========C==C===7=8==3=1=1=1=1=2=1=1=1==15=15=15=20=20=20=15=25=15==10=10=15=20=20=20=15=20=12==10=10=10=10=10=10=10==1=1=1=1=2=5=5=5=5=5=10=2=2=2=2=5=5=5=5==5=5=5=5=5=5=5=5=5=5=5=5=5=5=5=5=1=1=1=1=1===1=1=1=1=2=5=5=5=5=5=2=1=1==1============C======P===D===100===1===P1=========
出错后改为下面的输入(enq1=798对应的enq2需要再进行一次选择)
enq2===852===2008-08-02===798===1===1===1===1===1======B============P===D===100===1===P1=========
]]>
<![CDATA[
DBD::mysql::db do failed: Incorrect integer value: 'D' for column 'discount0' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq2 (id,time,enq1id,LANGUAGEid,ORIGINid,PRICEid,PAYMENTid,makerid,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("974","2008-09-15","883","2","1","1","1","222","3 DAYS","67
","38=30","3=12","","900=200= "," = = ","D","100","2","P1","DDB20308Q","")
enq2===974===2008-09-15===883===2===1===1===1===222===3 DAYS===67===38=30===3=12======900=200= === = = ===D===100===2===P1===DDB20308Q======
出错后改为下面的输入(enq1=798对应的enq2需要再进行一次选择)
enq2===974===2008-09-15===883===1===1===1===1===1======B============P===D===100===1===P1=========
enq2===974===2008-09-15===883===1===1===1===1===1======B============P===D===100===1===P1=========
DBD::mysql::db do failed: Incorrect integer value: '==D' for column 'disc0' at r
ow 1 at insert_tables.pl line 65.
INSERT INTO quo2 (id,time,ORIGINid,PRICEid,PAYMENTid,DELIVERY,money,percent0,dis
count0,percent,discount,price,D_FEE,total,memo,disc0,disc,price0) VALUES("1242",
"2008-09-11","1","1","1","10D","1","125","100","125=125=125=125","","","","","",
"==D","","")
quo2===1242===2008-09-11===1===1===1===10D===1===125===100===125=125=125=125====================D===============100===D0=======================
出错后改为下面的输入
quo2===1242===2008-09-11===1===1===1===10D===1===125===100===125=125=125=125==================100===============100===D0=======================
]]>
<![CDATA[
C:\database\perl>perl insert_tables.pl
This is insert_tables.pl.
Please input database table name=enq2
DBD::mysql::db do failed: Data truncated for column 'discount0' at row 1 at inse
rt_tables.pl line 65.
INSERT INTO enq2 (id,time,enq1id,LANGUAGEid,ORIGINid,PRICEid,PAYMENTid,makerid,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("974","2008-09-17","883","2","1","1","1","222","3 DAYS","67
","38=30","3=12","","900=200= "," = = ","96=96","96","2","P1","DDB20308Q","")
enq2===974===2008-09-17===883===2===1===1===1===222===3 DAYS===67===38=30===3=12======900=200= === = = ===96=96===96===2===P1===DDB20308Q======
enq2===974===2008-09-17===883===1===1===1===1===1======B============P===D===100===1===P1=========
makers数据有空格.
C:\database\perl>perl insert_tables.pl
This is insert_tables.pl.
Please input database table name=makers
DBD::mysql::db do failed: Incorrect integer value: '' for column 'id' at row 1 a
t insert_tables.pl line 65.
INSERT INTO makers (id,company,address,person,telfax,email,homepage,memo) VALUES
("","","","","","","","")
DBD::mysql::db do failed: Incorrect integer value: '' for column 'id' at row 1 a
t insert_tables.pl line 65.
INSERT INTO makers (id,company,address,person,telfax,email,homepage,memo) VALUES
("","","","","","","","")
C:\database\perl>perl insert_tables.pl
This is insert_tables.pl.
Please input database table name=owners
DBD::mysql::db do failed: Incorrect integer value: '' for column 'id' at row 1 a
t insert_tables.pl line 65.
INSERT INTO owners (id,company,address,person,telfax,email,homepage,memo) VALUES
("","","","","","","","")
]]>
<![CDATA[
Please input database table name=enq1
DBD::mysql::db do failed: Incorrect integer value: '' for column 'LANGUAGEid' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq1 (id,time,ourref,owner,ownerno,hullnoid,type1id,partsid,QTY,memo
,LANGUAGEid,makerid,enq2s,seriesid) VALUES("1535","2008-10-14","8101412","4","S0
8028","116","273","103=104=105=96=106=4=107=108=109=110=7","","2=2=15=2=5=10=2=2
=3=6=6","","2","1","1701")
DBD::mysql::db do failed: Incorrect integer value: '' for column 'LANGUAGEid' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq1 (id,time,ourref,owner,ownerno,hullnoid,type1id,partsid,QTY,memo
,LANGUAGEid,makerid,enq2s,seriesid) VALUES("1578","2008-10-16","8101601","33","K
3115","468","1414","5=6=7=8=9=10=11=12","","2=1=1=2=2=2=2=2","","1","153","1747"
)
enq1===1535===2008-10-14===8101412===4===S08028===116===273===103=104=105=96=106=4=107=108=109=110=7======2=2=15=2=5=10=2=2=3=6=6======2===1===1701===C
enq1===1535===2008-10-14===8101412===4===S08028===1===B===C===C======1===1===1701===C
Please input database table name=enq1
DBD::mysql::db do failed: Incorrect integer value: '' for column 'LANGUAGEid' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq1 (id,time,ourref,owner,ownerno,hullnoid,type1id,partsid,QTY,memo
,LANGUAGEid,makerid,enq2s,seriesid) VALUES("1578","2008-10-16","8101601","33","K
3115","468","1414","5=6=7=8=9=10=11=12","","2=1=1=2=2=2=2=2","","1","153","1747"
)
enq1===1578===2008-10-16===8101601===33===K3115===468===1414===5=6=7=8=9=10=11=12======2=1=1=2=2=2=2=2======1===153===1747===2
enq1===1578===2008-10-16===8101601===33===K3115===1===B===C===C======1===1===1747===2
Please input database table name=enq2
DBD::mysql::db do failed: Incorrect integer value: 'D' for column 'discount0' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq2 (id,time,enq1id,LANGUAGEid,ORIGINid,PRICEid,PAYMENTid,makerid,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("1701","2008-10-15","1535","1","1","1","1","222","","273","
103=104=105=96=106=4=107=108=109=110=7","","2=2=15=2=5=10=2=2=3=6=6","","42.48=5
3.1=0.24=9.44=0.41=3.19=0.24=53.1=0.88=1.53=0.12","D","100","2","P1","","")
DBD::mysql::db do failed: Incorrect integer value: 'D' for column 'discount0' at
row 1 at insert_tables.pl line 65.
INSERT INTO enq2 (id,time,enq1id,LANGUAGEid,ORIGINid,PRICEid,PAYMENTid,makerid,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("1747","2008-10-17","1578","1","1","1","1","153","","1414",
"5=6=7=8=9=10=11=12","","2=1=1=2=2=2=2=2","","9000=29000=5000=8000=5000=5000=450
0=6000","D","100","1","P1","","")
enq2===1701===2008-10-15===1535===1===1===1===1===222======273===103=104=105=96=106=4=107=108=109=110=7======2=2=15=2=5=10=2=2=3=6=6======42.48=53.1=0.24=9.44=0.41=3.19=0.24=53.1=0.88=1.53=0.12===D===100===2===P1=========
enq2===1701===2008-10-15===1535===1===1===1===1===1======B============P===D===100===1===P1=========
enq2===1701===2008-10-15===1535===1===1===1===1===222======273===103=104=105=96=106=4=107=108=109=110=7===2=2=15=2=5=10=2=2=3=6=6======42.48=53.1=0.24=9.44=0.41=3.19=0.24=53.1=0.88=1.53=0.12===D===100===2===P1=========
enq2===1747===2008-10-17===1578===1===1===1===1===153======1414===5=6=7=8=9=10=11=12======2=1=1=2=2=2=2=2======9000=29000=5000=8000=5000=5000=4500=6000===D===100===1===P1=========
enq2===1747===2008-10-17===1578===1===1===1===1===1======B============P===D===100===1===P1=========
enq2===1747===2008-10-17===1578===1===1===1===1===153======1414===5=6=7=8=9=10=11=12===2=1=1=2=2=2=2=2======9000=29000=5000=8000=5000=5000=4500=6000===D===100===1===P1=========
enq2===1927===2008-10-29===1721===1===1===1===1===132======458===8=9=8=9===8=16=8=16======6950=190=====70=80=====100===1===P1=========
==>这个数据有问题
]]>
返回