创建表时,UNIQUE KEY上的语法错误
问题描述:
我正尝试使用下面的代码在数据库中创建Tabe。但是,它不工作,我不明白为什么。创建表时,UNIQUE KEY上的语法错误
正在生成的错误是'UNIQUE KEY ID (ID)'
上的语法错误,但根据我正在使用的教程(以及我可以找到的文档),看起来没问题。
我也试过'UNIQUE ID (ID)'
和'UNIQUE ID'
,但我仍然得到语法错误。
CREATE TABLE wp_offices (
ID smallint(3) NOT NULL AUTO_INCREMENT,
office_created_by smallint(3) DEFAULT "0",
office_created_date datetime DEFAULT "0000-00-00 00:00:00" NOT NULL,
office_last_edited_by smallint(3) DEFAULT "0",
office_last_edited_date datetime DEFAULT "0000-00-00 00:00:00" NOT NULL,
office_name tinytext COLLATE latin1_general_ci,
address_1 tinytext COLLATE latin1_general_ci,
address_2 tinytext COLLATE latin1_general_ci,
town tinytext COLLATE latin1_general_ci,
county tinytext COLLATE latin1_general_ci,
postcode tinytext COLLATE latin1_general_ci,
telephone tinytext COLLATE latin1_general_ci,
fax tinytext COLLATE latin1_general_ci,
dx tinytext COLLATE latin1_general_ci,
email tinytext COLLATE latin1_general_ci,
google_maps text(256) COLLATE latin1_general_ci
)
UNIQUE KEY ID (ID);
有人能告诉我我做错了什么吗?谢谢。
答
它应该是在大括号
google_maps text(256) COLLATE latin1_general_ci,
UNIQUE KEY ID (ID)
);
答
内创建表的代码将
CREATE TABLE wp_offices(
ID SMALLINT(3) NOT NULL AUTO_INCREMENT ,
office_created_by SMALLINT(3) DEFAULT "0",
office_created_date DATETIME DEFAULT "0000-00-00 00:00:00" NOT NULL ,
office_last_edited_by SMALLINT(3) DEFAULT "0",
office_last_edited_date DATETIME DEFAULT "0000-00-00 00:00:00" NOT NULL ,
office_name TINYTEXT COLLATE latin1_general_ci,
address_1 TINYTEXT COLLATE latin1_general_ci,
address_2 TINYTEXT COLLATE latin1_general_ci,
town TINYTEXT COLLATE latin1_general_ci,
county TINYTEXT COLLATE latin1_general_ci,
postcode TINYTEXT COLLATE latin1_general_ci,
telephone TINYTEXT COLLATE latin1_general_ci,
fax TINYTEXT COLLATE latin1_general_ci,
dx TINYTEXT COLLATE latin1_general_ci,
email TINYTEXT COLLATE latin1_general_ci,
google_maps TEXT(256) COLLATE latin1_general_ci,
UNIQUE KEY ID(ID)
);
啊,谢谢。我使用的教程在这种情况下是错误的,但很高兴这很简单!谢谢。 –