mysql 创建表和外键

mysql> create table country(
　　　> country_id smallint unsigned not null auto_increment,
　　　>country varchar(50) not null,
　　   >last_update timestamp not null default current_timestamp on update current_timestamp,
　　   >primary key (country_id)
　　　>)engine=InnoDB default charset = utf8;

mysql> ccreate table city(
　　>city_id smallint unsigned not null auto_increment,
　　>city varchar(50) not null,
　　>country_id smallint unsigned not null,
　　>last_update timestamp not null default current_timestamp on update current_timestamp,
　　>primary key (city_id),
　　>key idx_fk_country_id (country_id),
　　>foreign key (country_id) references country (country_id)
　　>) ENGINE = InnoDB default charset=utf8;

mysql 创建表和外键

原文：http://www.cnblogs.com/yangxuming/p/6718094.html