EROR 1064 (42000) resolved: You have an error in. your SOL syntax. check the manual that corresponds to your MySQL server version

Error code

A friend in the fan group reported an error when inserting new data with SQL:

Error message: EROR 1064 (42000): You have an error in. your SOL syntax. check the manual that corresponds to your MySQL server version

Error translation

Error message translation:

Error: You have an error in.your SOL grammar.Check the manual corresponding to the MySQL server version

Reason for error

Reason for error: There is a problem with his new data statement

Workaround

Correct SQL new data statement:

insert into table name(column name,column name) values(values1,value 2)

or

insert into table name values(values1,value 2)

Modify the correct code and execute successfully: