1064 - you have an error in your sql syntax check the manual that corresponds to

 · mysql insert into Backtick_SymbolDemo(`Name`,'FileName') values('John','www.doorway.ru'); ERROR (): 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 ''FileName') values ('John','www.doorway.ru')' at line 1. To avoid this error either use the backtick symbol around the all column name or do not use .  · MySQL:: Re: Error Code: 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 'for f in 'C:\\Users\\Documents\\TEMP\*.csv' DO LOAD DATA INFILE '"$f"' INTO TABL' at . You can ask!. Earn. Earn Free Access Learn More Upload Documents.

You will get error: ERROR (): 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 '-DB' at line 1 Solution: mysql create database ` Test-DB `; So adding back tick around the database name will solve the issue. mysql insert into Backtick_SymbolDemo(`Name`,'FileName') values('John','www.doorway.ru'); ERROR (): 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 ''FileName') values ('John','www.doorway.ru')' at line 1. To avoid this error either use the backtick symbol around the all column name or do not use both the backtick or single quotes. MySQL:: Re: Error Code: 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 'for f in 'C:\\Users\\Documents\\TEMP\*.csv' DO LOAD DATA INFILE '"$f"' INTO TABL' at line 1. Re: Error Code:

How can I fix “Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server”? Most often comes with the code and is related with SQL syntax error. This kind of error has been seen reported mostly on MySQL but also on other type of. SQL answers related to “ERROR: Error You have an error in your SQL to fix You have an error in your SQL syntax; check the manual that corresponds.