bing_yu2年前
mysql> INSERT INTO money (username,balance ,province,age,sex) -> values('王宝强','120.02','上海','29',1), -> ('范冰冰','260.23','山东','40',0), -> ('黄晓明','180.02','山东','40',1), ->
bing_yu2年前
创建表 CREATE TABLE money ( id INT NOT NULL AUTO_INCREMENT , username VARCHAR(50) NOT NULL , balance FLOAT NOT NULL , province VARCHAR(20) NOT NULL , age TINYINT UNSIGNED NOT N
bing_yu2年前
复制创建 money 表时出错了: ERROR 1089 (HY000): Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys mysq