
MySQL Error 1064 - 42000
MySql Error:
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 XXX at line 1
MySQL error 1064 (42000) usually occurs when you have an error in the query syntax that was executed. One of the reasons that can give you this error is when you are trying to create an object (table/database) which is having a hyphen in its name.
Example:mysql> create database my-database;
How to fix: 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 '-database' at line 1
Solution:
Just wrap the object name with the hyphen with backtick to resolve the error.
mysql> create database `my-database`;
Have Questions? Post them here!
More Posts related to MySQL,
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- Connection Failed: 1130 PHP MySQL Error
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- How to clear mysql console screen
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- How to find AUTO_INCREMENT Fields value in MySQL table
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
More Posts:
- INSTALL_FAILED_INSUFFICIENT_STORAGE Error Android Emulator - Android
- Error:The SDK Build Tools revision (XX.X.X) is too low for project. Minimum required is XX.X.X - Android
- How to start/boot macOS in safe mode - Big Sur 11.0, Catalina 10.15, or Mojave 10.14 - MacOS
- Page actions are temporarily disabled [Google Search Console Page Crawling] - Google
- Android : How to make TextView Scrollable - Android
- How to check RAM details on Mac? - MacOS
- Access Windows share folder in Ubuntu Device in Network - Ubuntu
- Error running 'app': No target device found. - Android-Studio