各位帮看看:ADDRESS_FK 可以建出来,但 APPLE_FK 建不出来
提示说后面这两句有语法问题 ADID varchar(10) NOT NULL UNIQUE,
CONSTRAINT APPLE_ADDRESS_FK FOREIGN KEY(ADID) sql 如下:
drop table apple_fk;
drop table address_fk;CREATE TABLE ADDRESS_FK(
ADID varchar(10) PRIMARY KEY,
NATION VARCHAR(30) NOT NULL,
PROVINCE VARCHAR(30) NOT NULL,
POSTCODE VARCHAR(10) NOT NULL );CREATE TABLE APPLE_FK(
AID varchar(10) PRIMARY KEY,
NAME VARCHAR(20) NOT NULL,
COM VARCHAR(50),
PRICE double(5) NOT NULL,
ADID varchar(10) NOT NULL UNIQUE,
CONSTRAINT APPLE_ADDRESS_FK FOREIGN KEY(ADID)
REFERENCES ADDRESS_FK(ADID));
提示说后面这两句有语法问题 ADID varchar(10) NOT NULL UNIQUE,
CONSTRAINT APPLE_ADDRESS_FK FOREIGN KEY(ADID) sql 如下:
drop table apple_fk;
drop table address_fk;CREATE TABLE ADDRESS_FK(
ADID varchar(10) PRIMARY KEY,
NATION VARCHAR(30) NOT NULL,
PROVINCE VARCHAR(30) NOT NULL,
POSTCODE VARCHAR(10) NOT NULL );CREATE TABLE APPLE_FK(
AID varchar(10) PRIMARY KEY,
NAME VARCHAR(20) NOT NULL,
COM VARCHAR(50),
PRICE double(5) NOT NULL,
ADID varchar(10) NOT NULL UNIQUE,
CONSTRAINT APPLE_ADDRESS_FK FOREIGN KEY(ADID)
REFERENCES ADDRESS_FK(ADID));
drop table apple_fk;
drop table address_fk;CREATE TABLE ADDRESS_FK(
ADID varchar(10) PRIMARY KEY,
NATION VARCHAR(30) NOT NULL,
PROVINCE VARCHAR(30) NOT NULL,
POSTCODE VARCHAR(10) NOT NULL )
engine innodb;CREATE TABLE APPLE_FK(
AID varchar(10) PRIMARY KEY,
`NAME` VARCHAR(20) NOT NULL,
COM VARCHAR(50),
PRICE double(5,5) NOT NULL,
ADID varchar(10) NOT NULL UNIQUE,
CONSTRAINT APPLE_ADDRESS_FK FOREIGN KEY(ADID)
REFERENCES ADDRESS_FK(ADID))
engine innodb;
多谢大牛!