
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 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`;
-
Have Questions? Post them here!
More Posts related to MySQL,
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- 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]
- MySQL: Error Code: 1175 You are using safe update mode
- Connection Failed: 1130 PHP MySQL Error
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- Display List of Databases in mysql Command Line
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL Query for Schema/Structure of a Table
- How to find AUTO_INCREMENT Fields value in MySQL table
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- Identify MySQL version in MySQL Command Line Prompt
- How to clear MySQL Console Screen
More Posts:
- Python f-strings Formatted String Literals Syntax and Examples - Python
- macOS Ventura Login Item Added Google Chrome Notification - MacOS
- Google translate in spreadsheet - Google
- macOS: Text to Speech Command - say examples - MacOS
- Check version of pip package installer for Python - Python
- How to change TextView or EditText Text Color on Focus and on Press - Android
- JavaScript date in yyyy-MM-dd format - JavaScript
- Bypass domain name with credentials SharePoint, .Net site from IIS - SharePoint