mysql> DESCRIBE STUDENT;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| 姓名 | text | YES | | NULL | |
| 语文 | int(11) | NO | PRI | 0 | |
| 数学 | int(11) | YES | | NULL | |
| 英语 | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
4 rows in set (0.01 sec)mysql> ALTER TABLE STUDENT DROP CONSTRAINT 语文;
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 'CONST
RAINT 语文' at line 1
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| 姓名 | text | YES | | NULL | |
| 语文 | int(11) | NO | PRI | 0 | |
| 数学 | int(11) | YES | | NULL | |
| 英语 | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
4 rows in set (0.01 sec)mysql> ALTER TABLE STUDENT DROP CONSTRAINT 语文;
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 'CONST
RAINT 语文' at line 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货