Mysql外键创建1005 - Can't create table 'ds_article.#sql-770_b2' (errno: 150)错误

我执行了，没问题啊，能建外键的。
mysql> DROP TABLE IF EXISTS `ds_admin`;
Query OK, 0 rows affected, 1 warning (000 sec)
mysql> CREATE TABLE `ds_admin` (
-> `Admin_ID` int(11) NOT NULL AUTO_INCREMENT,
-> `username` varchar(20) NOT NULL,
-> `password` varchar(26) NOT NULL,
-> PRIMARY KEY (`Admin_ID`)
-> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (008 sec)
mysql>
mysql> DROP TABLE IF EXISTS `admin_log`;
Query OK, 0 rows affected, 1 warning (000 sec)
mysql> CREATE TABLE `admin_log` (
-> `ID` int(11) NOT NULL AUTO_INCREMENT,
-> `Admin_ID` int(11) DEFAULT NULL,
-> `time` date DEFAULT NULL,
-> `viscera` varchar(1000) DEFAULT NULL,
-> PRIMARY KEY (`ID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (008 sec)
mysql>
mysql> ALTER TABLE admin_log ADD FOREIGN KEY(Admin_ID) REFERENCES ds_admin(Admin
_ID) ON DELETE RESTRICT ON UPDATE RESTRICT;
Query OK, 0 rows affected (014 sec)
Records: 0 Duplicates: 0 Warnings: 0

以上就是关于Mysql外键创建1005 - Can't create table 'ds_article.#sql-770_b2' (errno: 150)错误全部的内容，包括:Mysql外键创建1005 - Can't create table 'ds_article.#sql-770_b2' (errno: 150)错误、、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！