一些SQL操作語句(8),parts_nu追加單位,enq2_price追加
返回
<![CDATA[
mysql> INSERT parts_nu (parts_Unit) VALUES('TABE');
Query OK, 1 row affected (0.06 sec)
mysql> select * from parts_nu;
+----+------------+
| id | parts_Unit |
+----+------------+
| 1 | PCS |
| 2 | SET |
| 3 | BOX |
| 4 | ROLL |
| 5 | PAIR |
| 6 | CAN |
| 7 | DOZ |
| 8 | KGS |
| 9 | MTR |
| 10 | SHT |
| 11 | TUBE |
| 12 | PKT |
| 13 | TIN |
| 14 | BTL |
| 15 | BAG |
| 16 | COIL |
| 17 | LTR |
| 18 | CASE |
| 19 | TABE |
+----+------------+
19 rows in set (0.00 sec)
============================================================
mysql> INSERT parts_nu (parts_Unit) VALUES('CASE');
Query OK, 1 row affected (0.20 sec)
mysql> select * from parts_nu;
+----+------------+
| id | parts_Unit |
+----+------------+
| 1 | PCS |
| 2 | SET |
| 3 | BOX |
| 4 | ROLL |
| 5 | PAIR |
| 6 | CAN |
| 7 | DOZ |
| 8 | KGS |
| 9 | MTR |
| 10 | SHT |
| 11 | TUBE |
| 12 | PKT |
| 13 | TIN |
| 14 | BTL |
| 15 | BAG |
| 16 | COIL |
| 17 | LTR |
| 18 | CASE |
+----+------------+
18 rows in set (0.00 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('LTR');
Query OK, 1 row affected (0.06 sec)
mysql> select * from parts_nu;
+----+------------+
| id | parts_Unit |
+----+------------+
| 1 | PCS |
| 2 | SET |
| 3 | BOX |
| 4 | ROLL |
| 5 | PAIR |
| 6 | CAN |
| 7 | DOZ |
| 8 | KGS |
| 9 | MTR |
| 10 | SHT |
| 11 | TUBE |
| 12 | PKT |
| 13 | TIN |
| 14 | BTL |
| 15 | BAG |
| 16 | COIL |
| 17 | LTR |
+----+------------+
17 rows in set (0.00 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('TIN');
Query OK, 1 row affected (0.08 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('BTL');
Query OK, 1 row affected (0.09 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('BAG');
Query OK, 1 row affected (0.03 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('COIL');
Query OK, 1 row affected (0.06 sec)
mysql> select * from parts_nu;
+----+------------+
| id | parts_Unit |
+----+------------+
| 1 | PCS |
| 2 | SET |
| 3 | BOX |
| 4 | ROLL |
| 5 | PAIR |
| 6 | CAN |
| 7 | DOZ |
| 8 | KGS |
| 9 | MTR |
| 10 | SHT |
| 11 | TUBE |
| 12 | PKT |
| 13 | TIN |
| 14 | BTL |
| 15 | BAG |
| 16 | COIL |
+----+------------+
16 rows in set (0.00 sec)
mscenq1_parts2.htm
<select name="<TMPL_VAR NAME="unit1">" size=1>
<option value="1">PCS</option>
<option value="2">SET</option>
<option value="3">BOX</option>
<option value="4">ROLL</option>
<option value="5">PAIR</option>
<option value="6">CAN</option>
<option value="7">DOZ</option>
<option value="8">KGS</option>
<option value="9">MTR</option>
<option value="10">SHT</option>
<option value="11">TUBE</option>
<option value="12">PKT</option>
<option value="13">TIN</option>
<option value="14">BTL</option>
<option value="15">BAG</option>
<option value="16">COIL</option>
</select>
mscshowpartsone.pl
@{ $t{units} } = qw/PCS SET BOX ROLL PAIR CAN DOZ KGS MTR SHT TUBE PKT/;
==> @{ $t{units} } = qw/PCS SET BOX ROLL PAIR CAN DOZ KGS MTR SHT TUBE PKT TIN BTL BAG COIL/;
]]>
<![CDATA[
mysql> select * from enq2_price;
+----+------------------+
| id | PRICE |
+----+------------------+
| 1 | EXW KOBE (OSAKA) |
| 2 | EXW JAPAN |
| 3 | FOB KOBE (OSAKA) |
| 4 | FCA |
| 5 | CFR KAOHSIUNG |
| 6 | EXW CHINA |
| 7 | EXW EUROPE |
| 8 | EXW KOREA |
+----+------------------+
8 rows in set (0.00 sec)
update enq2_price set PRICE='FCA JAPAN' where id = 4;
mysql> select * from enq2_price;
+----+------------------+
| id | PRICE |
+----+------------------+
| 1 | EXW KOBE (OSAKA) |
| 2 | EXW JAPAN |
| 3 | FOB KOBE (OSAKA) |
| 4 | FCA JAPAN |
| 5 | CFR KAOHSIUNG |
| 6 | EXW CHINA |
| 7 | EXW EUROPE |
| 8 | EXW KOREA |
+----+------------------+
8 rows in set (0.00 sec)
insert into enq2_price (PRICE) values('FCA KOREA');
insert into enq2_price (PRICE) values('FCA CHINA');
insert into enq2_price (PRICE) values('FCA EUROPE');
insert into enq2_price (PRICE) values('FCA JAPAN');
mysql> select * from enq2_price;
+----+------------------+
| id | PRICE |
+----+------------------+
| 1 | EXW KOBE (OSAKA) |
| 2 | EXW JAPAN |
| 3 | FOB KOBE (OSAKA) |
| 4 | FCA |
| 5 | CFR KAOHSIUNG |
| 6 | EXW CHINA |
| 7 | EXW EUROPE |
| 8 | EXW KOREA |
| 9 | FCA KOREA |
| 10 | FCA CHINA |
| 11 | FCA EUROPE |
| 12 | FCA JAPAN |
+----+------------------+
12 rows in set (0.00 sec)
]]>
<![CDATA[
mysql> select * from enq2_price;
+----+------------------+
| id | PRICE |
+----+------------------+
| 1 | EXW KOBE (OSAKA) |
| 2 | EXW JAPAN |
| 3 | FOB KOBE (OSAKA) |
| 4 | FCA |
| 5 | CFR KAOHSIUNG |
+----+------------------+
5 rows in set (0.08 sec)
mysql> INSERT enq2_price (PRICE) VALUES('EXW CHINA');
Query OK, 1 row affected (0.19 sec)
mysql> INSERT enq2_price (PRICE) VALUES('EXW EUROPE');
Query OK, 1 row affected (0.03 sec)
mysql> INSERT enq2_price (PRICE) VALUES('EXW KOREA');
Query OK, 1 row affected (0.01 sec)
mysql> select * from enq2_price;
+----+------------------+
| id | PRICE |
+----+------------------+
| 1 | EXW KOBE (OSAKA) |
| 2 | EXW JAPAN |
| 3 | FOB KOBE (OSAKA) |
| 4 | FCA |
| 5 | CFR KAOHSIUNG |
| 6 | EXW CHINA |
| 7 | EXW EUROPE |
| 8 | EXW KOREA |
+----+------------------+
8 rows in set (0.00 sec)
]]>
<![CDATA[
mysql> select * from parts_nu;
+----+------------+
| id | parts_Unit |
+----+------------+
| 1 | PCS |
| 2 | SET |
| 3 | BOX |
| 4 | ROLL |
| 5 | PAIR |
| 6 | CAN |
| 7 | DOZ |
| 8 | KGS |
| 9 | MTR |
+----+------------+
9 rows in set (0.11 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('SHT');
Query OK, 1 row affected (0.17 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('TUBE');
Query OK, 1 row affected (0.05 sec)
mysql> INSERT parts_nu (parts_Unit) VALUES('PKT');
Query OK, 1 row affected (0.05 sec)
mysql> select * from parts_nu;
+----+------------+
| id | parts_Unit |
+----+------------+
| 1 | PCS |
| 2 | SET |
| 3 | BOX |
| 4 | ROLL |
| 5 | PAIR |
| 6 | CAN |
| 7 | DOZ |
| 8 | KGS |
| 9 | MTR |
| 10 | SHT |
| 11 | TUBE |
| 12 | PKT |
+----+------------+
12 rows in set (0.00 sec)
]]>
<![CDATA[
mscenq1_parts2.htm
<select name="<TMPL_VAR NAME="unit1">" size=1>
<option value="1">PCS</option>
<option value="2">SET</option>
<option value="3">BOX</option>
<option value="4">ROLL</option>
<option value="5">PAIR</option>
<option value="6">CAN</option>
<option value="7">DOZ</option>
<option value="8">KGS</option>
<option value="9">MTR</option>
<option value="10">SHT</option>
<option value="11">TUBE</option>
<option value="12">PKT</option>
</select>
]]>
返回
皮山县|
招远市|
穆棱市|
定边县|
凤台县|
颍上县|
滦南县|
连山|
驻马店市|
中西区|
仁寿县|
江山市|
新兴县|
桑植县|
汉中市|
嵊州市|
福贡县|
宁安市|
稷山县|
平舆县|
凤山县|
吐鲁番市|
泉州市|
新泰市|
类乌齐县|
吉林省|
沙洋县|
舟山市|
通州市|
惠州市|
三穗县|
米易县|
陇川县|
涿州市|
济宁市|
泸溪县|
全州县|
惠水县|
武冈市|
石首市|
深水埗区|