MySQL操作程序三十三(检查表格数据程序,show_items.pl)
返回
<![CDATA[
quo2
4189
7397
8222
main_type1
962
5355
6164
XXXSERIES= ??
owners===186===The Contractor Trading Company
owners===212===Cesmel Europe GmbH
makers===513===(株）日本防蝕工業
makers===546===ITALMAR SARDINIA
makers===559===GOLDEN SHIPPING AGENCY CORP.
makers===569===TianJin Five Ocean
makers===577===Inchcape Shipping Services
makers===585===MASHIN SHOKAI H.K. LTD
makers===641===QINHUANGDAO SEATERON INTERNATIONAL
enq2
5454
5913
8188
8315
8635
8638
8656
9051
9353
10132
10953
11017
11034
11648
12031
12818
12859
13120
13201
13393
13394
13672
13888
13913
13915
******************************************************************************
C:\database\perl>perl insert_tables.pl
This is insert_tables.pl.
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,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("5454","2009-08-11","4815","1","1","1","1","234","","2986",
"1=2=3=4=5=6=7=8=9=10","","","","","","31.5=31.5=42=26=26=31.4=42=10.5=12.54=31.
4","D","100","2","P1")
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,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("5913","2009-09-02","5186","1","1","1","1","155","","44==31
70","","","","","","","=77","1","P1","","")
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,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("8188","2010-01-18","0","1","1","1","1","74","","4005==1360
","","","","","","","=85","1","P1","","")
DBD::mysql::db do failed: Incorrect integer value: '=D' for column 'discount0' a
t 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("8315","2010-01-25","7254","1","1","1","1","108","","2509==
2294","","","","","","=D","100","1","P1","","")
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,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("8635","2010-02-01","0","2","1","1","1","222","7D","1566==2
75==254","","","","","","","==D","100","2","P1","D2D55072Q")
DBD::mysql::db do failed: Incorrect integer value: '=D' for column 'discount0' a
t 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("8638","2010-02-02","0","1","1","1","1","33","","4148==1482
","","","","","","=D","100","1","P1","","")
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,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("8656","2010-02-16","7609","1","1","1","1","442","","4238",
"1=2=3=4=5=6=7","4=2=2=1=2=2=1","","1900=740=1000=550=550=550=22500","","","",""
,"=85","1","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("9051","2010-03-16","7951","2","1","1","1","223","2D","783=
=4405==3644","==1=2","","=2=2","","==10=40","D","100","3","P1","509-4-101925",""
)
DBD::mysql::db do failed: Incorrect integer value: '=100' 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("9353","2010-03-26","8221","1","1","1","1","51","","44","1=
5","20=6","","8500=11000","","=100","1","P1","","","")
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,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("10132","2010-05-17","8915","1","1","1","1","155","","1840"
,"127=128=129=130=131=132=133=134=135=136=137=138=139=140=141=142=143=144=145=14
6=147=148=149=150=151=152=153=154=155=156=157=158=159=160=161=162=163=164=165=16
6","6=6=12=12=6=6=50=30=40=50=12=2=12=12=4=30=2=12=10=10=3=12=4=6=20=5=5=1=1=1=3
=3=2=1=3=4=4=4=12=4","","10000=14500=480=320=22400=56000=270=360=350=250=2900=31
500=1400=1400=1700=50=39700=420=260=110=98300=11100=11600=450=1700=1580=1900=851
00=63500=77300=1200=1000=24000=9900=0=0=0=6500=250=2300","","","","100","1","P1"
,"")
DBD::mysql::db do failed: Incorrect integer value: '=16200=80=23=30=23=180=40=14
00' 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("10953","2010-02-24","0","1","1","1","1","144","30D/7D","11
63","44=45=46=47=48=49=50=51","","","","","=16200=80=23=30=23=180=40=1400","100=
100=100=100=100=100=100=100","100","1","P1","")
DBD::mysql::db do failed: Incorrect integer value: '=D' for column 'discount0' a
t 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("11017","2010-07-01","0","1","1","1","1","153","","5164==51
66","","","","","","=D","100","1","P1","","")
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,D
ELIVERY,type1id,partsid,QTY,memo,price,discount,discount0,money,price1,makerref,
disc,charges) VALUES("11034","2010-07-02","9739","1","1","1","1","222","","271",
"30=62=111=112=145=192=209","1=1=1=1=12=9=1","","33=69.3=49.5=49.5=0.22=11=27.5"
,"","","","100","2","P1","D2D68141Q")
DBD::mysql::db do failed: Incorrect integer value: '=100' 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("11648","2010-08-10","10289","1","1","1","1","108","","5400
","1=2=3","2=2=1","","1200=2160=1440","","=100","1","P1","","","")
DBD::mysql::db do failed: Incorrect integer value: '==100' 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("12031","2010-08-31","10652","1","1","1","1","20","","3372=
=5546","6=7=8==1=2","24=3=4==4=2","","4200=12500=5400=8200=6500","","==100","1",
"P1","","","")
]]>
<![CDATA[
mysql> show columns from enq2;
+------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| time | date | YES | | NULL | |
| enq1id | int(11) | YES | | NULL | |
| LANGUAGEid | int(11) | YES | | NULL | |
| ORIGINid | int(11) | YES | | NULL | |
| PRICEid | int(11) | YES | | NULL | |
| PAYMENTid | int(11) | YES | | NULL | |
| makerid | int(11) | YES | | NULL | |
| DELIVERY | text | YES | | NULL | |
| type1id | text | YES | | NULL | |
| partsid | text | YES | | NULL | |
| QTY | text | YES | | NULL | |
| memo | text | YES | | NULL | |
| price | text | YES | | NULL | |
| discount | text | YES | | NULL | |
| discount0 | int(11) | YES | | NULL | |
| money | int(11) | YES | | NULL | |
| price1 | text | YES | | NULL | |
| makerref | text | YES | | NULL | |
| disc | text | YES | | NULL | |
| charges | text | YES | | NULL | |
+------------+---------+------+-----+---------+----------------+
21 rows in set (0.19 sec)
C:\database\perl>perl show_items.pl
Please input table name(*.txt)=enq2
Please input id number=5454
enq2:enq2
id:5454
time:2009-08-11
enq1id:4815
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:234
DELIVERY:
type1id:2986
partsid:1=2=3=4=5=6=7=8=9=10
QTY:
memo:
price:
discount:
discount0:
money:31.5=31.5=42=26=26=31.4=42=10.5=12.54=31.4
price1:D
makerref:100
disc:2
charges:P1
修改后
C:\database\perl>perl show_items.pl
Please input table name(*.txt)=enq2
Please input id number=5454
enq2:enq2
id:5454
time:2009-08-11
enq1id:4815
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:234
DELIVERY:
type1id:2986
partsid:1=2=3=4=5=6=7=8=9=10
QTY:
memo:
price:31.5=31.5=42=26=26=31.4=42=10.5=12.54=31.4
discount:D
discount0:100
money:2
price1:P1
makerref:OM0908-224
disc:
charges:
--------------------------------------------------------------
Please input table name(*.txt)=enq2
Please input id number=5913
enq2:enq2
id:5913
time:2009-09-02
enq1id:5186
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:155
DELIVERY:
type1id:44==3170
partsid:
QTY:
memo:
price:
discount:
discount0:
money:=77
price1:1
makerref:P1
disc:
charges:
修改后
Please input table name(*.txt)=enq2
Please input id number=5913
enq2:enq2
id:5913
time:2009-09-02
enq1id:5186
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:155
DELIVERY:
type1id:44==3170
partsid:
QTY:
memo:
price:
discount:
discount0:77
money:1
price1:P1
makerref:
disc:
charges:
修改后
C:\database\perl>perl show_items.pl
Please input table name(*.txt)=enq2
Please input id number=9051
enq2:enq2
id:9051
time:2010-03-16
enq1id:7951
LANGUAGEid:2
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:223
DELIVERY:2D
type1id:783==4405==3644
partsid:==1=2
QTY:
memo:=2=2
price:==10=40
discount:D
discount0:100
money:3
price1:P1
makerref:509-4-101925
disc:
charges:
-------------------------------------------------------
追究原因,价格输入时有空格输入?
C:\database\perl>perl show_items.pl
Please input table name(*.txt)=enq2
Please input id number=9353
enq2:enq2
id:9353
time:2010-03-26
enq1id:8221
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:51
DELIVERY:
type1id:44
partsid:1=5
QTY:20=6
memo:
price:8500=11000
discount:
discount0:=100
money:1
price1:P1
makerref:
disc:
charges:
修改后
C:\database\perl>perl show_items.pl
Please input table name(*.txt)=enq2
Please input id number=9353
enq2:enq2
id:9353
time:2010-03-26
enq1id:8221
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:51
DELIVERY:
type1id:44
partsid:1=5
QTY:20=6
memo:
price:8500=11000
discount:
discount0:100
money:1
price1:P1
makerref:
disc:
charges:
C:\database\perl>perl show_items.pl
Please input table name(*.txt)=enq2
Please input id number=10132
enq2:enq2
id:10132
time:2010-05-17
enq1id:8915
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:155
DELIVERY:
type1id:1840
partsid:127=128=129=130=131=132=133=134=135=136=137=138=139=140=141=142=143
=144=145=146=147=148=149=150=151=152=153=154=155=156=157=158=159=160=161=162=163
=164=165=166
QTY:6=6=12=12=6=6=50=30=40=50=12=2=12=12=4=30=2=12=10=10=3=12=4=6=20=5=
5=1=1=1=3=3=2=1=3=4=4=4=12=4
memo:
price:10000=14500=480=320=22400=56000=270=360=350=250=2900=31500=1400=140
0=1700=50=39700=420=260=110=98300=11100=11600=450=1700=1580=1900=85100=63500=773
00=1200=1000=24000=9900=0=0=0=6500=250=2300
discount:
discount0:
money:
price1:100
makerref:1
disc:P1
charges:
C:\database\perl>perl show_items.pl
Please input table name(*.txt)=enq2
Please input id number=10132
enq2:enq2
id:10132
time:2010-05-17
enq1id:8915
LANGUAGEid:1
ORIGINid:1
PRICEid:1
PAYMENTid:1
makerid:155
DELIVERY:
type1id:1840
partsid:127=128=129=130=131=132=133=134=135=136=137=138=139=140=141=142=143
=144=145=146=147=148=149=150=151=152=153=154=155=156=157=158=159=160=161=162=163
=164=165=166
QTY:6=6=12=12=6=6=50=30=40=50=12=2=12=12=4=30=2=12=10=10=3=12=4=6=20=5=
5=1=1=1=3=3=2=1=3=4=4=4=12=4
memo:
price:10000=14500=480=320=22400=56000=270=360=350=250=2900=31500=1400=140
0=1700=50=39700=420=260=110=98300=11100=11600=450=1700=1580=1900=85100=63500=773
00=1200=1000=24000=9900=0=0=0=6500=250=2300
discount:
discount0:100
money:1
price1:P1
makerref:
disc:
charges:
enq2==>10953
enq2==>11017
enq2==>11034
enq2==>11648
enq2==>12031
enq2==>12818
enq2==>12859
enq2==>13120
enq2==>13201
enq2==>13393
enq2==>13394
]]>
注意discount0和money是integer value!
<![CDATA[
# show table items
# show_items.pl
use strict;
my(%t,@name,@one,@fld,$n);
print "Please input table name(*.txt)=";
chop($t{table}=<STDIN>);
$t{table} = $t{table} . '.txt';
print "Please input id number=";
chop($t{id}=<STDIN>);
open(IN,"../txt/$t{table}") or die "Can't open the file $t{table}\n";
while(<IN>){
if ( $. == 2 ) {
chop;
@name = split(/===/);
} elsif ( $. > 2 ) {
chop;
@fld = split(/===/);
if ( $fld[1] == $t{id} ) {
@one = @fld;
last;
}
}
}
close(IN);
for $n ( 0 .. $#name ) {
printf ("%12s:",$name[$n]);
print $one[$n],"\n";
}
]]>
<![CDATA[
mysql> show columns from quo2;
+-----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| time | date | YES | | NULL | |
| ORIGINid | int(11) | YES | | NULL | |
| PRICEid | int(11) | YES | | NULL | |
| PAYMENTid | int(11) | YES | | NULL | |
| DELIVERY | text | YES | | NULL | |
| money | int(11) | YES | | NULL | |
| percent0 | int(11) | YES | | NULL | |
| discount0 | int(11) | YES | | NULL | |
| percent | text | YES | | NULL | |
| discount | text | YES | | NULL | |
| price | text | YES | | NULL | |
| D_FEE | text | YES | | NULL | |
| total | text | YES | | NULL | |
| memo | text | YES | | NULL | |
| disc0 | int(11) | YES | | NULL | |
| disc | text | YES | | NULL | |
| price0 | text | YES | | NULL | |
+-----------+---------+------+-----+---------+----------------+
18 rows in set (0.02 sec)
C:\database\perl>perl insert_tables.pl
This is insert_tables.pl.
Please input database table name=quo2
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=")
DBD::mysql::db do failed: Incorrect integer value: 'NOTE: ITEM 1(K2) INCLUDES IT
EM 2,3,4' 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("7397",
"2010-01-29","1","1","1","2D","1","115","100","115=115=115=115","D","125000","",
"","","NOTE: ITEM 1(K2) INCLUDES ITEM 2,3,4","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("8222",
"2010-04-02","1","1","1","25D","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=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=15000=110=11
0=110=120=120=15000=15000","D","30000=4200=6750=3750=600=3300=825=720=30=1800=16
50=22500=225000=33750=30=8250=450=45=45=9750=720=22500=30=30=11250=10500=20250=5
250=37=22=75=600=900=675=300=750=9750=4500=600=0=1635=48=12=16=7260=7260=14300=1
3200=6480=7500","","","","=100","D0","200=28=45=25=4=22=5.5=4.8=0.2=12=11=150=15
00=225=0.2=55=3=0.3=0.3=65=4.8=150=0.2=0.2=75=70=135=35=0.25=0.15=0.5=4=6=4.5=2=
5=65=30=4=0=10.9=0.32=0.08=0.11=6600=6600=13000=11000=5400=4600=")
quo2==>4189
quo2==>7397
quo2==>8222
]]>
<![CDATA[
输入时要把return键去掉!
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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
("","","","","","","","")
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[
解决不存在的TABLE问题
DBD::mysql::db do failed: Table 'cookbook.a005999' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006000' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006001' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006001' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006001' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006001' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006002' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006003' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006003' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006004' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006005' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006005' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006006' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006006' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006007' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006007' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006008' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006009' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006010' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006011' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006012' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006013' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006013' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006013' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006014' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006016' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006017' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006018' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006019' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006020' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006021' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006021' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006022' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006023' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006023' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006024' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006025' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006026' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006027' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006027' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006028' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006029' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006029' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006029' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006030' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006031' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006031' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006031' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006032' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006033' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006034' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006035' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006037' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006037' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006037' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006037' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006037' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006038' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006040' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006041' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006042' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006042' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006042' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006042' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006042' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006043' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006044' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006045' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006046' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006047' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006047' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006048' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006049' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006050' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006051' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006051' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006052' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006052' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006052' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006053' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006053' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006054' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006055' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006056' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006057' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006058' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006058' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006058' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006058' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006058' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
DBD::mysql::db do failed: Table 'cookbook.a006059' doesn't exist at input_ptable
s.pl line 86.
]]>
返回