首先，我创建它创造了一个城市的表，但是当我创建第二个表显示错误..
我不明白..请人有任何想法......

[SQL] CREATE TABLE `area` (

`id`  int(11) NOT NULL AUTO_INCREMENT ,

`name`  varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,

`city_id`  int(11) NULL DEFAULT NULL ,

PRIMARY KEY (`id`),

FOREIGN KEY(`city_id`) REFERENCES city (id) 

)

ENGINE=INNODB

DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci

AUTO_INCREMENT=1

CHECKSUM=0

ROW_FORMAT=DYNAMIC

DELAY_KEY_WRITE=0

;

[错误] 1005 - 无法创建表'virtualmarket.area'（errno的:150）| chinta123