Код ошибки 1064 mysql

So, you’re creating a custom SQL query to perform a task in the database. After putting the code together and running it in PHPmyAdmin it responds with a 1064 error. It may look similar to this:

The 1064 error displays any time you have an issue with your SQL syntax, and is often due to using reserved words, missing data in the database, or mistyped/obsolete commands. So follow along and learn more about what the 1064 error is, some likely causes, and general troubleshooting steps.

Note: Since syntax errors can be hard to locate in long queries, the following online tools can often save time by checking your code and locating issues:

Causes for the 1064 error

This may seem cryptic since it is a general error pointing to a syntax issue in the SQL Query statement. Since the 1064 error can have multiple causes, we will go over the most common things that will result in this error and show you how to fix them. Follow along so you can get your SQL queries updated and running successfully.

Using Reserved Words

Every version of MySQL has its own list of reserved words. These are words that are used for specific purposes or to perform specific functions within the MySQL engine. If you attempt to use one of these reserved words, you will receive the 1064 error. For example, below is a short SQL query that uses a reserved word as a table name.

How to fix it:

Just because the word alter is reserved does not mean it cannot be used, it just has special requirements to use it as the MySQL engine is trying to call the functionality for the alter command. To fix the issue, you will want to surround the word with backticks, this is usually the button just to the left of the “1” button on the keyboard. The code block below shows how the code will need to look in order to run properly.

Missing Data

Sometimes data can be missing from the database. This causes issues when the data is required for a query to complete. For example, if a database is built requiring an ID number for every student, it is reasonable to assume a query will be built to pull a student record by that ID number. Such a query would look like this:

If the $id is never properly filled in the code, the query would look like this to the server:

Since there is nothing there, the MySQL engine gets confused and complains via a 1064 error.

How to fix it:

Hopefully, your application will have some sort of interface that will allow you to bring up the particular record and add the missing data. This is tricky because if the missing data is the unique identifier, it will likely need that information to bring it up, thus resulting in the same error. You can also go into the database (typically within phpMyAdmin) where you can select the particular row from the appropriate table and manually add the data.

Mistyping of Commands

One of the most common causes for the 1064 error is when a SQL statement uses a mistyped command. This is very easy to do and is easily missed when troubleshooting at first. Our example shows an UPDATE command that is accidentally misspelled.

How to fix it:

Be sure to check your commands prior to running them and ensure they are all spelled correctly.

Below is the syntax for the correct query statement.

Obsolete Commands

Some commands that were deprecated (slated for removal but still allowed for a period of time) eventually go obsolete. This means that the command is no longer valid in the SQL statement. One of the more common commands is the ‘TYPE‘ command. This has been deprecated since MySQL 4.1 but was finally removed as of version 5.1, where it now gives a syntax error. The ‘TYPE‘ command has been replaced with the ‘ENGINE‘ command. Below is an example of the old version:

This should be replaced with the new command as below:

Error 1064 Summary

As you can see there is more than one cause for the 1064 error within MySQL code. Now, you know how to correct the issues with your SQL Syntax, so your query can run successfully. This list will be updated as more specific instances are reported.

Thoughts on “ MySQL 1064 Error: You have an error in your SQL syntax ”

Hi, Jacob! Sorry to hear that you’re running into trouble here. How exactly are you creating the database? Is this part of the installation of some software, or through cPanel’s database utility?

Your issue is a coding one with your database. We do not provide support for coding, so I recommend that you speak with an experienced developer or programmer. You can also find many tutorials for MySQL online that may provide the information you seek. Apologies that we cannot provide a direct solution for your issue.

I get this error when trying to import a database to phpmyadmin

3 errors were found during analysis.

Variable name was expected. (near ” ” at position 5)
Variable name was expected. (near ” ” at position 26)
Unrecognized statement type. (near “Host” at position 0)

Host: localhost (Version: 5.6.16) # Date: 2015-06-03 23:46:52 # Generator: MySQL-Front 5.3 (Build 4.122) /*!40101 SET NAMES utf8 */

MySQL said: Documentation
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘Host: localhost (Version: 5.6.16)
# Date: 2015-06-03 23:46:52
# Generator: My’ at line 1

phpmy admin seemingly has a problem with this:

# Host: localhost (Version: 5.6.16)
# Date: 2015-06-03 23:46:52
# Generator: MySQL-Front 5.3 (Build 4.122)

/*!40101 SET NAMES utf8 */;

ERROR 1064 (42000) at line 6: 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 ‘

<link rel' at line 1

Operation failed with exitcode 1

It looks like there is an issue with how the query is coded. Unfortunately, we are unable to provide direct support for coding questions, so I recommend that you speak with an experienced developer or programmer. That said, I’d start by examining the early link syntax to see if it might be something simple like a missing comma or semi-colon. Apologies that we cannot provide a direct solution for your issue.

Hi I got this error when trying to import mysql database into phpmyadmin using a local XAMPP server. Please what probably go wrong?

Error:
Static analysis:

10 errors were found during analysis.

Unexpected character. (near “ <” at position 224)
Unexpected beginning of statement. (near “DOCTYPE” at position 2)
Unexpected beginning of statement. (near “HTML” at position 10)
Unexpected beginning of statement. (near “html” at position 16)
Unexpected beginning of statement. (near “lang” at position 21)
Unexpected beginning of statement. (near “‘en’” at position 26)
Unexpected beginning of statement. (near “dir” at position 31)
Unexpected beginning of statement. (near “‘ltr’” at position 35)
Unexpected beginning of statement. (near “meta” at position 42)
Unrecognized statement type. (near “charset” at position 47)

MySQL said: Documentation
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘<meta name="ref' at line 1

The error indicates there is an issue with your syntax. This depends on your version of MySQL. I recommend that you review the documentation for the version of MySQL you are using to ensure you have the proper syntax in your code.

1 errors were found during analysis.

Unexpected beginning of statement. (near “id11897681_admin” at position 0)
SQL query:

id11897681_admin SET time_zone = “+00:00”

MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘id11897681_admin
SET time_zone = “+00:00″‘ at line 1

Sorry for the problem that you’re getting with the SQL Syntax. I’m not 100% sure of the issue but it appears to be possible syntax near the ID you’re using. The documentation shows three backticks before the timezone. Check it out in the MariaDB’s official documentation: https://mariadb. com/kb/en/library/time-zones/.

Hi Is there any possibilities to get a error code 00088x from SQL database, if there pls help me to fix it

Please provide more information and we can look into the issue further. Describe where/when the error occurs and provide the query.

Hello
mysql error but Apache is running xampp is a problem ( Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums)

Someone can help me.

Hello – A MySQL shutdown can happen for any number of reasons. We would advise following the recommendation of using the log files to determine when the shutdown occurred and if the event can be duplicated. You may need to submit a ticket with our live technical support team, or you may need to speak with an experienced MySQL developer for further assistance. If you are getting a specific error due to Syntax, we would need more information on the MySQL query where the error is happening. If you have any further questions or comments, please let us know.

Executing SQL script in server

ERROR: Error 1064: 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 ‘(16) NOT NULL,

`password` (32) NOT NULL,

`create_time`’ at line 5

CREATE TABLE IF NOT EXISTS `mydb`.`user_1` (

`username` (16) NOT NULL,

`password` (32) NOT NULL,

`create_time` NULL DEFAULT CURRENT_TIMESTAMP)

SQL script execution finished: statements: 9 succeeded, 1 failed

Fetching back view definitions in final form.

Executing SQL script in server

ERROR: Error 1064: 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 ‘(16) NOT NULL,

`password` (32) NOT NULL,

`create_time`’ at line 5

CREATE TABLE IF NOT EXISTS `mydb`.`user_1` (

`username` (16) NOT NULL,

`password` (32) NOT NULL,

`create_time` NULL DEFAULT CURRENT_TIMESTAMP)

SQL script execution finished: statements: 9 succeeded, 1 failed

Fetching back view definitions in final form.

Thanks for post on the MYSQL syntax error. The error indicates that the variable you’re building is not being properly defined. You need to indicated what each item is going to be. For example:

Specify what your variables are supposed to be in the table, then it should work.

I am getting this error when using SQl Developer and trying to “monitor sessions” in a mysql database. I can access the mysql database and look at tables, run queries, etc., and I have increased max_allowed_packets per a few other posts.

Sorry for the problem with the error when trying monitor sessions. We would need to see the MySQL query in order to troubleshoot the problem. Otherwise, we recommend speaking with an experienced database developer to resolve the issue.

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 ‘default(Cus_name, Rs_status, Acc_type, Acc_class, Currency, Init_deposit, Dob, Gender, M’ at line 1.
this error how to solve plz help me

Hello Sandar – sorry for the syntax error. We would need to see more of the MySQL query in order to determine the problem. I would recommend that you speak with an experienced developer or review your code to find the syntax issue that is causing the error to appear.

hello I’am getting an error through my workbench while I’m trying to forward engineer.

CREATE TABLE IF NOT EXISTS `electronics`.`customer_order` (

`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`amount` DECIMAL(6,2) NOT NULL,

`date_created` TIMESTAMP NOT NULL,

`confirmation_number` INT NOT NULL,

`customer_id` INT UNSIGNED NOT NULL,

INDEX `fk_customer_order_customer` (`customer_id` ASC) VISIBLE,

FOREIGN KEY (`customer_id`)

REFERENCES `electronics`.`customer` (`id`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

COMMENT = ‘Maintain the details of the customer order’

SQL script execution finished: statements: 9 succeeded, 1 failed

ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘

FOREIGN KEY (`customer_id`)

According to the MySQL checker provided above, the following line needs to be checked:
INDEX `fk_customer_order_customer` (`customer_id` ASC) VISIBLE,

when i import a database from wamp i get an error that ther is an error in line one

create databse student_mgt charset utf-8;

Depends on how you’re doing the import. If you’re logged into WAMP and you have already created that database, then that line would not be needed and you can just import the structure. If you have any further questions or comments, please let us know.

for the following database im getting these errors, could you please help me encounter teh errors.

<?php
$c_album=”CREATE TABLE IF NOT EXISTS album (
aid int(11) NOT NULL auto_increment,
aperformer_id int(11) NOT NULL default ‘0’,
aname varchar(200) NOT NULL,
bio_short text,
bio_long text,
PRIMARY KEY (aid),
KEY aperformer_id (aperformer_id),
KEY aname (aname)
) ENGINE=MyISAM;”;

$c_fav=”CREATE TABLE IF NOT EXISTS fav (
id int(11) NOT NULL auto_increment,
track_id int(11) NOT NULL default ‘0’,
performer_id int(11) default NULL,
album_id int(11) default NULL,
name varchar(200) NOT NULL,
duration varchar(6) default NULL,
last_played varchar(20) default NULL,
times_played int(11) NOT NULL default ‘0’,
year varchar(4) default NULL,
user_id int(11) NOT NULL default ‘0’,
fav_name varchar(80) NOT NULL default ”,
PRIMARY KEY (id),
KEY fav_name (fav_name),
KEY user_id (user_id),
KEY track_id (track_id)
) ENGINE=MyISAM;”;

$c_fav_shares=”CREATE TABLE IF NOT EXISTS fav_shares (
id int(11) NOT NULL auto_increment,
owner_id int(11) NOT NULL default ‘0’,
fav_name varchar(80) NOT NULL,
share_id int(11) NOT NULL default ‘0’,
PRIMARY KEY (id)
) ENGINE=MyISAM”;

$c_performer=”CREATE TABLE IF NOT EXISTS performer (
pid int(11) NOT NULL auto_increment,
pname varchar(200) NOT NULL,
bio_short text,
bio_long text,
PRIMARY KEY (pid),
KEY pname (pname)
) ENGINE=MyISAM;”;

$c_queue=”CREATE TABLE IF NOT EXISTS queue (
qid bigint(20) NOT NULL auto_increment,
user_name varchar(80) NOT NULL,
track_id bigint(20) NOT NULL default ‘0’,
PRIMARY KEY (qid),
KEY user_name (user_name)
) ENGINE=MyISAM;”;

$c_track=”CREATE TABLE IF NOT EXISTS `track` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`performer_id` int(11) DEFAULT NULL,
`album_id` int(11) DEFAULT NULL,
`track_no` smallint(6) DEFAULT NULL,
`name` varchar(200) NOT NULL,
`duration` varchar(6) DEFAULT NULL,
`last_played` varchar(20) DEFAULT NULL,
`times_played` int(11) NOT NULL DEFAULT ‘0’,
`year` varchar(4) DEFAULT NULL,
`path` text COLLATE latin1_danish_ci,
`echonest_id` varchar(20) NOT NULL DEFAULT ‘-1’,
`echonest_tempo` varchar(8) NOT NULL DEFAULT ‘-1’,
`echonest_loudness` varchar(8) NOT NULL DEFAULT ‘-1’,
`echonest_danceability` varchar(8) NOT NULL DEFAULT ‘-1’,
`echonest_energy` varchar(8) NOT NULL DEFAULT ‘-1’,
`echonest_mode` varchar(2) NOT NULL DEFAULT ‘-1’,
`echonest_key` varchar(2) NOT NULL DEFAULT ‘-1’,
`echonest_time_signature` varchar(2) NOT NULL DEFAULT ‘-1’,
`echonest_status` varchar(10) NOT NULL DEFAULT ‘-1’,
`echonest_liveness` varchar(8) NOT NULL DEFAULT ‘-1’,
`echonest_speechiness` varchar(8) NOT NULL DEFAULT ‘-1’,
`echonest_acousticness` varchar(8) NOT NULL DEFAULT ‘-1’,
`echonest_valence` varchar(8) NOT NULL DEFAULT ‘-1’,
PRIMARY KEY (`id`),
KEY `performer_id` (`performer_id`),
KEY `album_id` (`album_id`),
KEY `name` (`name`),
KEY `year` (`year`),
KEY `echonest_tempo` (`echonest_tempo`),
KEY `echonest_loudness` (`echonest_loudness`),
KEY `echonest_danceability` (`echonest_danceability`),
KEY `echonest_energy` (`echonest_energy`),
KEY `echonest_mode` (`echonest_mode`),
KEY `echonest_key` (`echonest_key`),
KEY `echonest_time_signature` (`echonest_time_signature`),
KEY `echonest_liveness` (`echonest_liveness`),
KEY `echonest_speechiness` (`echonest_speechiness`),
KEY `echonest_acousticness` (`echonest_acousticness`),
KEY `echonest_valence` (`echonest_valence`)
) ENGINE=MyISAM;”;

$c_user=”CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL,
`email` varchar(80) NOT NULL DEFAULT ‘0’,
`password` varchar(80) NOT NULL,
`password_salt` varchar(40) NOT NULL DEFAULT ‘0’,
`last_login` varchar(40) NOT NULL DEFAULT ”,
`last_ip` varchar(40) NOT NULL DEFAULT ”,
`admin` tinytext NOT NULL,
`lang` char(2) NOT NULL DEFAULT ”,
`count` mediumint(9) NOT NULL DEFAULT ‘0’,
`enqueue` char(1) DEFAULT ‘0’,
`cssfile` varchar(80) NOT NULL DEFAULT ”,
`icon_dir` varchar(80) DEFAULT NULL,
`disp_last_played` char(1) DEFAULT ‘1’,
`disp_times_played` char(1) DEFAULT ‘1’,
`disp_id_numbers` char(1) DEFAULT ‘1’,
`disp_jump_to` char(1) DEFAULT ‘1’,
`disp_duration` char(1) DEFAULT ‘1’,
`disp_totals` char(1) DEFAULT ‘1’,
`disp_related_performers` char(1) DEFAULT ‘1’,
`confirm_delete` char(1) DEFAULT ‘1’,
`can_download` char(1) DEFAULT ‘0’,
`can_upload` char(1) DEFAULT ‘0’,
`disp_download` char(1) DEFAULT ‘0’,
`disp_upload` char(1) DEFAULT ‘0’,
`disp_lyrics` char(1) DEFAULT ‘0’,
`hide_icon_text` char(1) NOT NULL DEFAULT ‘0’,
`disp_fav_shares` char(1) DEFAULT ‘0’,
`disp_small_images` char(1) DEFAULT ‘1’,
`browse_albums_by_covers` char(1) DEFAULT ‘0’,
`browse_performer_by_picture` char(1) DEFAULT ‘0’,
`autoplay` char(1) DEFAULT ‘0’,
`autoplay_num_tracks` int(11) NOT NULL DEFAULT ‘1’,
`autoplay_list` varchar(80) DEFAULT ‘Tracks’,
`autoplay_last` char(1) DEFAULT ‘0’,
`autoplay_last_list` varchar(80) DEFAULT NULL,
`ask4favoritelist` char(1) DEFAULT ‘0’,
`ask4favoritelist_disp_suggestion` char(1) NOT NULL DEFAULT ‘0’,
`disp_now_playing` char(1) DEFAULT ‘0’,
`disp_now_playing_add2favorite` char(1) NOT NULL DEFAULT ‘0’,
`avoid_duplicate_entries` char(1) DEFAULT ‘1’,
`auto_add2favorite` char(1) NOT NULL DEFAULT ‘0’,
`auto_add2favorite_create_new` char(1) NOT NULL DEFAULT ‘1’,
`auto_add2favorite_prefix` varchar(50) NOT NULL DEFAULT ‘AmpJuke_Automatically_added’,
`disp_help` char(1) DEFAULT ‘1’,
`welcome_num_items` smallint(6) NOT NULL DEFAULT ’10’,
`welcome_content_1` varchar(80) DEFAULT ‘Recently played tracks’,
`welcome_content_2` varchar(80) DEFAULT ‘Random albums’,
`welcome_content_3` varchar(80) DEFAULT ‘Random albums’,
`lame_local_enabled` char(1) DEFAULT ‘1’,
`lame_local_parameters` varchar(80) DEFAULT NULL,
`lastfm_active` char(1) DEFAULT ‘0’,
`lastfm_username` varchar(80) DEFAULT NULL,
`lastfm_password` varchar(80) DEFAULT NULL,
`xspf_active` char(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `password` (`password`)
) ENGINE=MyISAM;”;

?>
here are the errors :

Static analysis:

7 errors were found during analysis.

SQL query:

FIX sqlstate 42000 – mysql error 1064 – you have an error in your sql syntax

Sqlstate 42000 Is a general code that come together with other number. Most often comes with the code 1064 and is related with SQL syntax error. This kind of error has been seen reported mostly on MySQL but also on other type of databases. This happen because your command is not a valid one within the “Structured Query Language” or SQL. Syntax errors are just like grammar errors in linguistics. In the following article we will try to explain the MySQL error 1064 but not only. Also we will show other error codes that comes together with Sqlstate[42000].

Full view of my sql error code 1064:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL (or any other like MariaDb) server version for the right syntax to use near (And here is the part of the code where the error comes)

sqlstate 42000 – mysql error 1064 – you have an error in your sql syntax

Other error codes related with Sqlstate 42000:

Understand and FIX MySQL error 1064 – sqlstate 42000

SQL 1064 means that MySQL can’t understand your command!

This type of error first need to be understood and after that you can fix it. The common causes of this error are:

If you see words like “near” or “at line”, you need to check for problems in those lines of the code before the command ends.

How do I Fix SQL Error Code 1064?

So in general the error tells you where the parser encountered the syntax error. MySQL also suggest how to fix it. Check the example below …..

In some cases the PHP commands has wrong lines. Create SQL commands using programing language can be the good example of this. So you will need to check and fix those commands. Use echo, console. log(), or its equivalent to show the entire command so you can see it.

The error can occur also when you misspell a command (e. g. instead of UPDATE you write UDPATE). This can occur often since are so easy to miss. To prevent this, make sure that you review your command for any typing error before running it. There are a lot of online syntax checkers that can help to debug your queries.

Reserved words are words that vary from one MySQL version to another. Every version has its list of keywords that are reserved. They are used to perform specific functions in the MySQL engine. If you read the error and identified that occurred on an object identifier, check that it isn’t a reserved word (and, if it is, be sure that it’s properly quoted). “If an identifier contains special characters or is a reserved word, you must quote it whenever you refer to it.” You can find a full list of the reserved words specific for each MySQL version and their usage requirements at MySQL. com.

Another possible reason for the sqlstate 42000 MySQL error 1064 is when you use outdated commands. As Platforms grow and change, some commands that were useful in the past are replaced by more efficient ones. A number of commands and keywords have been deprecated. This mean that they are due for removal, but still allowed for a short period of time before they turn obsolete. On cases that you have an older backup of a MySQL database that you want to import, a quick solution is to just search and replace “TYPE=InnoDB” with “ENGINE=InnoDB”.

If the relevant data missing from the database which is required for the query, you’re obviously going to run into problems. Using phpMyAdmin or MySQL Workbench you can enter the missing data. Interface of the application allow you to add the missing data manually to an appropriate row of the table.

You have an error in your sql syntax

“You have an error in your sql syntax” – Example 1

The error code generated jointly with the statement “syntax error or access violation”, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL (or any other like MariaDB) server version for the right syntax to use near” and after that the part of SQL code where the issue is. So in simple way, the error view is showing you also where is the error. For example we have the error:

So how to understand this?

from is a keyword in SQL. You may not use it as a column name without quoting it. In MySQL, things like column names are quoted using back ticks, i. e. `from`. Or you can just rename the column.

Another example of “You have an error in your sql syntax” sqlstate 42000 – Example 2

The above query is missing a closing parenthesis in the query:

Just put a parenthesis ) before that apostrophe and it should work.

MariaDB error 1064 – Example 3

An example with MariaDB version issue. Trying to do example of tagging and when:

Reason is that is using MariaDB and JSON columns are only supported by MySQL. Convert to MySQL to resolve the issue.

MariaDB error 1064

Fix error 1064 mysql 42000 while creating a database – Example 4

MySQL error 1064 can be appearing also while you are creating database using hyphen in the name like Test-Db. This can be solved by using back tick around the database name properly or remove the hyphen in the database name.

You will get error:

So adding back tick around the database name will solve the issue.

Transfer WordPress MySQL database to another server

Exporting WordPress database to another server can also be cause the 1064 error. Can be resolved by choosing the compatibility mode and changing the database version to the current version you’re using. Please select the compatibility mode under the advanced tab when performing a backup and after that click the auto-detect file character set when restoring the MySQL database.

Read Also –

Conclusions:

The reason behind the error it’s related closely to the end of error message. We would need to see the SQL query to understand completely the issue you’re facing. So this is the reason that we can’t completely fix the MySQL error 1064 but we exposed some examples for you. You will need to review the documentation for the version of MySQL that you are having this error appear with and your syntax to fix the problem. There are multiple reasons for its cause. We suggest you perform the sqlstate 42000 error fixes if only has experience on MySQL database.