MySQL操作程序五十(mscenq1.pl,d

MySQL操作程序五十(mscenq1.pl,d_engine.pl,删除type)

需要利用qtn_input.pl再次调整enq2,再到quo2.pl,所以没有问题! ------------------------------------------------ mysql> select * from quo2 where id = 12397\G *************************** 1. row *************************** id: 12397 time: 2012-02-11 ORIGINid: 1 PRICEid: 1 PAYMENTid: 5 DELIVERY: NULL money: 1 percent0: 115 discount0: 100 percent: 115=115=115 discount: D price: 460=255=382 D_FEE: NULL total: NULL memo: NULL disc0: 100 disc: D0 price0: 400=222=333 pi_ok: 1 1 row in set (0.00 sec) 删除后 ------------------------------------------------ mysql> select * from enq1 where id = 12397\G *************************** 1. row *************************** id: 12397 time: 2012-01-03 ourref: C010301 owner: 335 ownerno: GCL10-SP-E-030 hullnoid: 319 type1id: 574 partsid: 15=16=17 QTY: 2=3=22 memo: NULL LANGUAGEid: 1 makerid: 223 enq2s: 13947 seriesid: 1 tmp_pname: NULL tmp_pcode: NULL tmp_pqty: NULL 1 row in set (0.00 sec) mysql> select * from quo2 where id = 12397\G *************************** 1. row *************************** id: 12397 time: 2012-02-11 ORIGINid: 1 PRICEid: 1 PAYMENTid: 5 DELIVERY: NULL money: 1 percent0: 115 discount0: 100 percent: 115=115=115=115=115=115 discount: D price: 115=230=345=460=255=382 D_FEE: NULL total: NULL memo: NULL disc0: 100 disc: D0 price0: 100=200=300=400=222=333 pi_ok: 1 1 row in set (0.00 sec) 删除前 ------------------------------------------------ mysql> select * from enq1 where id = 12397\G *************************** 1. row *************************** id: 12397 time: 2012-01-03 ourref: C010301 owner: 335 ownerno: GCL10-SP-E-030 hullnoid: 319 type1id: 574 partsid: 15=16=17 QTY: 2=3=22 memo: NULL LANGUAGEid: 1 makerid: 223 enq2s: 13947 seriesid: 1 tmp_pname: NULL tmp_pcode: NULL tmp_pqty: NULL 1 row in set (0.00 sec) mysql> select * from quo2 where id = 12397\G *************************** 1. row *************************** id: 12397 time: 2012-02-11 ORIGINid: 1 PRICEid: 1 PAYMENTid: 5 DELIVERY: NULL money: 1 percent0: 115 discount0: 100 percent: 115=115=115=115=115=115 discount: D price: 115=230=345=460=255=382 D_FEE: NULL total: NULL memo: NULL disc0: 100 disc: D0 price0: 100=200=300=400=222=333 pi_ok: 1 1 row in set (0.00 sec) 删除前 ------------------------------------------------ mysql> select * from enq1 where id = 12397\G *************************** 1. row *************************** id: 12397 time: 2012-01-03 ourref: C010301 owner: 335 ownerno: GCL10-SP-E-030 hullnoid: 319 type1id: 386==574 partsid: 2=3=4==15=16=17 QTY: 2=3=4==2=3=22 memo: NULL LANGUAGEid: 1 makerid: 223 enq2s: 13947 seriesid: 1==1 tmp_pname: NULL tmp_pcode: NULL tmp_pqty: NULL 1 row in set (0.00 sec) mysql> select * from quo2 where id = 12397\G *************************** 1. row *************************** id: 12397 time: 2012-02-11 ORIGINid: 1 PRICEid: 1 PAYMENTid: 5 DELIVERY: NULL money: 1 percent0: 115 discount0: 100 percent: 115=115=115=115=115=115 discount: D price: 115=230=345=460=255=382 D_FEE: NULL total: NULL memo: NULL disc0: 100 disc: D0 price0: 100=200=300=400=222=333 pi_ok: 1 1 row in set (0.00 sec)