MySQL中的错误

1

[SQL]alter table tb_wechat_auth add UNIQUE INDEX(open_id);
[Err] 1071 - Specified key was too long; max key length is 767 bytes

解决办法:右键表,然后点击设计表,中把open_id的varchar长度变小即可,

ERROR 1005 (HY000): Can't create table 'o2o.tb_product_img' (errno: 150)当出现下面错误的时候

看链接:https://blog.csdn.net/yiluxiangqian7715/article/details/47747613;讲解的很好。

原文地址:https://www.cnblogs.com/xiaoruirui/p/10848952.html