create table eOrder
(
orderId int not null AUTO_INCREMENT,
phone varchar(11),
goodsId bigint,
orderTime time,
sate varchar(10),
name varchar(20),
primary key (orderId),
foreign key(name) references eUser(name)
(
orderId int not null AUTO_INCREMENT,
phone varchar(11),
goodsId bigint,
orderTime time,
sate varchar(10),
name varchar(20),
primary key (orderId),
foreign key(name) references eUser(name)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
其中最后一行是设置数据库的编码的!