MySQL操作程序三十七(makers table增加 nation)
返回
作業(yè)內(nèi)容
- 注意修改其他用到makersTABLE的地方?
- mscqtn_input.htm,不修改
- mscenq1.htm,仕入先檢索,mscs_header.pl,不修改
mscenq1.htm,仕入先追加,mscshowadd2.pl,msc234.htm修改
mscenq1.pl,輸入項目的改行符號刪除
$string =~ s/\r//;
$string =~ s/\n//;
- msc233.htm修改
mscupdate.pl不修改
- msc232.htm修改
mscshowall.pl不修改
- mscdatabase.htm修改
mscshowall.pl不修改
msc231.htm修改
- makers的column增加
<![CDATA[
mysql> ALTER TABLE makers ADD nationid INT NOT NULL DEFAULT 2;==>OK
Query OK, 749 rows affected (0.22 sec)
Records: 749 Duplicates: 0 Warnings: 0
ALTER TABLE makers ADD nationid INT SET DEFAULT 2;==>NG
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'SET D
EFAULT 2' at line 1
ALTER TABLE makers DROP nationid;
ALTER TABLE makers ALTER nationid SET DEFAULT 2;==>沒有改變
mysql> insert into makers (nationid) values("2");==>只插入了一個!
Query OK, 1 row affected (0.08 sec)
mysql> show columns from makers;
+----------+-----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| company | char(100) | YES | | NULL | |
| address | char(100) | YES | | NULL | |
| person | char(50) | YES | | NULL | |
| telfax | char(100) | YES | | NULL | |
| email | char(100) | YES | | NULL | |
| homepage | char(100) | YES | | NULL | |
| memo | char(200) | YES | | NULL | |
| nationid | int(11) | YES | | NULL | |
+----------+-----------+------+-----+---------+----------------+
9 rows in set (0.02 sec)
ALTER TABLE makers ADD nationid INT AFTER memo;
mysql> show columns from makers;
+----------+-----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| company | char(100) | YES | | NULL | |
| address | char(100) | YES | | NULL | |
| person | char(50) | YES | | NULL | |
| telfax | char(100) | YES | | NULL | |
| email | char(100) | YES | | NULL | |
| homepage | char(100) | YES | | NULL | |
| memo | char(200) | YES | | NULL | |
+----------+-----------+------+-----+---------+----------------+
8 rows in set (0.24 sec)
]]>
返回
托克逊县|
濮阳县|
定安县|
贵阳市|
大姚县|
穆棱市|
黑龙江省|
淳化县|
文化|
宿州市|
徐水县|
阜宁县|
巴马|
阿合奇县|
双牌县|
普兰店市|
宾川县|
乡城县|
金乡县|
泗洪县|
开平市|
惠来县|
海盐县|
东兴市|
阿荣旗|
富平县|
海伦市|
海安县|
当雄县|
东海县|
沈丘县|
滦平县|
炎陵县|
尉犁县|
阿巴嘎旗|
河池市|
台山市|
涟源市|
河池市|
江西省|
驻马店市|