数据库表建立关于表名的问题

Question

CREATE TABLE userextra (
uid int(5) NOT NULL,
uname varchar(20) NOT NULL,
col_uni varchar(20) DEFAULT NULL,
maj_dep varchar(20) DEFAULT NULL,
grade int(4) DEFAULT '0',
type varchar(255) DEFAULT NULL,
PRIMARY KEY (uid),
UNIQUE KEY uname (uname),
CONSTRAINT userextra_ibfk_1 FOREIGN KEY (uid) REFERENCES userbasic (uid) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
我根据这串代码在navicat建立数据库表后为什么一直说我表名是错误的

Answer 1

外键关联那一条语句有问题
CONSTRAINT userextra_ibfk_1 FOREIGN KEY (uid) REFERENCES userbasic (uid) ON DELETE CASCADE ON UPDATE NO ACTION
你再仔细检查一下，建表的要求