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

返回
需要利用qtn_input.pl再次調(diào)整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)
返回
西华县| 虹口区| 万盛区| 都江堰市| 莱芜市| 华亭县| 长白| 鄂州市| 信丰县| 化德县| 丰宁| 手机| 万全县| 晋江市| 虎林市| 沂水县| 竹北市| 平利县| 龙州县| 福鼎市| 杭锦后旗| 宁夏| 合水县| 陆川县| 湘潭县| 慈溪市| 墨竹工卡县| 丰城市| 乌拉特中旗| 保定市| 微山县| 苏尼特左旗| 湄潭县| 山西省| 泾源县| 定远县| 仁怀市| 天台县| 玉环县| 阳山县| 新余市|