create table USER
(
id INT UNSIGNED not null primary key,
money SMALLINT UNSIGNED not null
) TYPE=MyISAM ;create table SEED
(
id TINYINT UNSIGNED not null primary key,
name VARCHAR(8) not null UNIQUE,
value TINYINT UNSIGNED not null
) ENGINE=MyISAM ;create table GROW
(
master int UNSIGNED not null,
seedid TINYINT UNSIGNED not null,
time DATE not null,
primary key (seedid,master),
foreign key (seedid) references SEED(id)on delete cascade on update cascade ,//这个外键出错,建不了
foreign key (master) references USER(id)on delete cascade on update cascade) ENGINE=InnoDB;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货