use Jack;
create table SalesRegion(SalesAreaID int(7) not null auto_increment,SalesAreaName varchar(8),salesManager varchar(8),primary key(SalesAreaID));
use Jack;
create table Salesman(
SalesmanID int(7)not null auto_increment,
SalemanName Varchar(6) not null,
SalesmanTel char(9),
SAID int(7) not null,
foreign key(SAID)references SalesRegion(SalesAreaID),
primary key(SalesmanID));
use Jack;
create table Order(
OrderID int(7) not null auto_increment,
Date datetime,
TotalAmount float(9) not null,
SMID int(7) not null,
CAID int(7) not null,
primary key(OrderID),
foreign key(SMID)references Salesman(SalesmanID),
foreign key(CAID)references Client(AccountID));加红标粗中有错误求MYsql大神回答
------解决方案--------------------
报什么错误?是不是外键引用的时候出问题了 语句本身没什么问题啊.
------解决方案--------------------
如果需要我帮你移到mysql专区就引用,不引用了