- 注意1064 - You have an error in yo
- mysql 5.7版本 出现 ERROR 1064 (42000
- 【2020-06-25】ERROR 1064 (42000):
- Mysql中遇到的几种报错及其解决办法
- [Err] 1064 - You have an error i
- ERROR 1064 (42000): You have an
- ERROR 1064 (42000): You have an
- ERROR 1064 (42000): You have an
- 1064 - You have an error in your
- 错误：ERROR 1064 (42000): You have
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 'rank,
@gen:=gender
from person,(select @rank:=0,@gen:=null) temp
' at line 5
如果出现1064 - You have an error in your SQL syntax这个错误，一定要注意自己数据库里面的字段是否和mysql里面的关键字重合如果重合就会报错，关于mysql80关键字到这里mysql字段，有问题一定去官方文档找，搞不定再去百度，这样大大节省时间，毕竟人家说的很明白了，这是99%程序员的通病报错就百度，让后一整天就浪费了 。
网友评论