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)
返回
潮州市| 枝江市| 桓台县| 子洲县| 肇州县| 阳江市| 应城市| 岳阳市| 青浦区| 清丰县| 定襄县| 吴忠市| 平果县| 郑州市| 封丘县| 永定县| 龙里县| 炎陵县| 新闻| 江阴市| 崇文区| 罗源县| 凤台县| 昔阳县| 渭南市| 南充市| 焦作市| 汉沽区| 盐边县| 自贡市| 武宣县| 宝兴县| 晋宁县| 柳林县| 崇明县| 隆回县| 临武县| 林甸县| 长乐市| 黄浦区| 启东市|