用带有外键的sql语句创建mysql表出错
lshoo 2005-12-06 09:42:34 用带外键的sql语句:
---------------------------
create table voterregistration (
ssn integer not null,
firstname varchar(32) not null,
lastname varchar(32) not null,
countynumber integer not null,
primary key(SSN),
foreign key(countynumber) references county);
--------------------------
创建voterregistration表时,用命令行执行时提示:
------------------------
ERROR 1005 (HY000): Can't create table '.\test\voterregstration.frm' (errno: 150);
-----------------
用Mysql-Front3.2执行时提示:
-------------------------
SQL执行错误#1005.从数据库的响应:
Can't create table '.\test\voterregstration.frm'(errno: 150)。
--------------------------
运行环境:windows xp sp2, MySQL 4.1.15.
另外试过多次,凡是用有定义外键的sql语句来创建表都会失败,不知道是原因?
另外:county表已经创建成功,附county的sql语句:
create table county (
countynumber integer not null auto_increment,
countyname varchar(32),
state varchar(32),
primary key(countynumber));