![MySQL Error 1064 - 42000 MySQL Error 1064 - 42000](https://code2care.org/howto/mysql-error-1064-42000-you-have-an-error-in-your-sql-syntax-fix/images/MySQL Error 1064 - 42000.png)
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 X 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`;
Facing issues? Have Questions? Post them here! I am happy to answer!
Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.
Follow him on: X
You can also reach out to him via e-mail: rakesh@code2care.org
- MySQL Workbench could not detect any MySQL server running. This means that MySQL is not installed or is not running.
- Fix: pip install mysqlclient error: subprocess-exited-with-error
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL: Error Code: 1175 You are using safe update mode
- Display List of Databases in mysql Command Line
- How to install MySQL Workbench on Mac (M1/M2)
- [macOS] Fix: MySQL ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- MySQL: How to know which Database Schema you are on in Terminal
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
- MySQL Workbench - Connection Warning - Incompatible/nonstandard server version or connection protocol detected
- MySQL: How to Select Database via Terminal/Command Line
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- Connection Failed: 1130 PHP MySQL Error
- Identify MySQL version in MySQL Command Line Prompt
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- How to Create Database in MySQL
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- How to query database table names [MySQL/Oracle/SQL Server]
- How to clear MySQL Console Screen
- java: cannot infer type for local variable, cannot use var on variable without initializer - Java
- Command to unzip or extract tar.gz file on Linux or macOS? - Linux
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists - MySQL
- Mac Terminal Find Command History - MacOS
- Fix: Failed in attempting to update the source: winget - Windows
- [Notepad++] Remove CR Carriage Return and LF Line feed (CRLF) - NotepadPlusPlus
- Toast not getting displayed Android App - Android
- How to Exit a Loop in Python Code - Python