1.Column ‘SNO‘ in field list is ambiguous2.the right syntax to use near ‘rank char)‘ at line 1

1.Column 'SNO' in field list is ambiguous

解决方案：指定数据库，避免指代不清问题

 

 

2.SQL Error [1064] [42000]: 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 char)' at line 1

解决方案：MYSQL的保留字不要使用，换个名字，具体有哪些可以参见博客

https://blog.csdn.net/wukong_666/article/details/70208749