MySQL创建外键报错ERROR 3780 (HY000): Referencing column ‘user_id’ and referenced column ‘id’ in foreign key constraint ‘fk_user_id’ are incompatible.

MySQL创建外键报错ERROR 3780 (HY000): Referencing column ‘user_id’ and referenced column ‘id’ in foreign key constraint ‘fk_user_id’ are incompatible.

原因：两个数据表中创建外键的数据类型不一致

我的错误是一个表是int，一个是bigint，这种的也算做是不一致的

解决办法：将数据类型修改为一致的即可
相关阅读:
小程序短信验证码倒计时变量作用域
 File syncing and sharing software with file encryption and group sharing, emphasis on reliability and high performance.
图片合并与截断
 宽度分离
 无宽度准则
 linux系统/var/log目录下的信息详解
 Connection Phase Packets
select version();desc mysql.user;
mysql user password plugin
Please read "Security" section of the manual to find out how to run mysqld as root!
原文地址：https://www.cnblogs.com/jiliangqian/p/15720778.html