![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
牛哞哞杂记
终身学习,成为更好的自己,公众号:牛哞哞杂记
展开
-
Column 'openid' in on clause is ambiguous
报错,分两种 1.数据库报错 Column ‘openid’ in on clause is ambiguous 原因: on子句中的列’openid’是不明确的 解决办法: 做连表查询时,字段无法被区分是在哪张表 可以给表设置 “别名” ,通过别名引导查询表 举个栗子: 其中 g 与 u 就是两张表的别名 select name,rank from grade g inner join user...原创 2019-12-25 14:46:29 · 1696 阅读 · 0 评论 -
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL
运行sql文件时,出现这个错误: [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘USING BTREE ) ENGINE=InnoDB AUTO_IN...原创 2019-08-11 21:11:06 · 489 阅读 · 0 评论