This is due to the syntax problem of SQL statements, and everyone’s situation is different
mine is
Original: select teacherno, teachername, vote from t_ Vote
reports an error
change to: select * from t_ Vote
success
Read More:
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- MySQL Build table error: You have an error in your SQL syntax； check the manual that corresponds to your MySQL ser
- ERROR 1064 (42000): You have an error in your SQL syntax； check the manual that corresponds to your
- MySQL Change password failure prompt: ERROR 1064(42000):You have an error in your SQL syntax: check the corresponds to your M
- MYSQL Use cmd to change root password error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha
- Mysql 8.0.13 Enabling remote access (ERROR 1064 (42000): You have an error in your SQL syntax; check the manual th)
- [Solved] java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
- How to Check the most CPU consuming 50 queries in MYSQL
- Bulk Update Error: #Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the m
- [Solved] MySQL Install Error: GPG check FAILED
- [Solved] MySQL: Syntax error or access violation: 1055 Expression #1 of SELECT list is not …
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- MySQL Install Error: MySQL error 1042: Unable to connect to any of the specified MySQL hosts
- The setobject() method reports an error. The parameter index out of range and MySQL syntax error exception report an error