1.创建表test6:外键名为test3_fk
mysql>createtabletest6(
->idint,
->test_namevarchar(32),
->constrainttest3_fkforeignkey(test_name)referencesstudent(name)
->);
QueryOK,0rowsaffected(0.40sec)
mysql>desctest6;
+-----------+-------------+------+-----+---------+-------+
|Field|Type|Null|Key|Default|Extra|
+-----------+-------------+------+-----+---------+-------+
|id|int(11)|YES||NULL||
|test_name|varchar(32)|YES|MUL|NULL||
+-----------+-------------+------+-----+---------+-------+
2rowsinset(0.06sec)
2.删除外键test3_fk;
mysql>altertabletest6dropforeignkeytest3_fk;
QueryOK,0rowsaffected(0.13sec)
Mysql报错1091解决办法_关于MYSQL:外键删除后 查询表发现外键依旧存在 再删一次会报错:原因及相关解决办法...
