作者wtuxxj (fire)
看板Database
标题[SQL ] FOREIGN KEY
时间Mon Mar 4 08:44:17 2013
各位好，请教一下问题
我先建立food及drink table後再建立order table
但总会错误在"REFERENCES food(foodid),..."
请教，该如何解决
谢谢
1. order_table table
- id
- username
- foodid
- drinkid
Create Command:
mysql>
create table order_table(
id int not null auto_increment,
user_name varchar(26) not null,
foodid int(11) not null,
drinkid int(11) not null,
primary key(id),
FOREIGN KEY foodid REFERENCES food(foodid),
FOREIGN KEY drinkid REFERENCES drink(drinkid)
)ENGINE=innodb;
2. food table
- foodid
- name
Create Commnad
mysql>
create table food (
foodid int(11) not null auto_increment,
name varchar(26) not null,
primary key(foodid)
)ENGINE=innodb;
3. drink table
- drinkid
- name
Create Command
create table drink (
drinkid int(11) not null auto_increment,
name varchar(26) not null,
primary key(drinkid)
)ENGINE=innodb;
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.134.94.102
※ 编辑: wtuxxj 来自: 220.134.94.102 (03/04 09:05)