MySQL唯一索引错误？

Question

CREATE TABLE tblUser 
( 

    CREATE UNIQUE INDEX i_ITUsername ON tblUser (ITUsername), 
    CREATE UNIQUE INDEX i_email ON tblUser (email), 
    CREATE INDEX i_disability ON tblUser (disability), 
    CREATE INDEX i_name ON tblUser (name) 
) TYPE = MyISAM; 

任何人都可以看到为什么我得到一个错误在第一个唯一索引线？据我所知，没有任何错误:(

Answer 1

第一个错误是你有一列两个数据类型，

mobilePhone long int UNSIGNED not null, -- choose one INT or LONG 
housePhone long int UNSIGNED, 

第二个是你声明像TSQL，这里是为MySQL，

primary key (ITUsername), 
UNIQUE i_ITUsername (ITUsername), 
UNIQUE i_email (email), 
KEY i_disability (disability), 
KEY i_name (name) 

• SQLFiddle Demo