直接po截图和代码
# -----------------------------------------------------------
alter table testMyIndex add (hometown VARCHAR(45) KEY,money FLOAT UNIQUE); #正确
#报错了,Multiple primary key defined 提示已经有primary key(主键)了
#alter table testMyIndex add (remarks VARCHAR(50) KEY,bankNumber VARCHAR(16) UNIQUE);
# -----------------------------------------------------------
报错信息如下:
[SQL]alter table testMyIndex add (remarks VARCHAR(50) KEY,bankNumber VARCHAR(16) UNIQUE);
[Err] 1068 - Multiple primary key defined
#报错了,Multiple primary key defined 提示已经有primary key(主键)了