ERROR 1064 (42000): You have an error in your SQL syntax

MySQL ERROR 1064 (42000) is the most common SQL syntax error. The server tells you where the syntax breaks by pointing near a specific part of your query. Most cases are simple typos or missing punctuation.

What It Means

MySQL’s parser could not understand your SQL statement. The error message includes a snippet of the query near the problem area, helping you locate the exact position of the syntax violation.

Why It Happens

• Missing or extra commas in SELECT or INSERT column lists.
• Unmatched single quotes, double quotes, or parentheses.
• Using a reserved keyword (SELECT, FROM, WHERE, ORDER, etc.) as a table or column name without backticks.
• Typo in a function name (e.g., NOW() misspelled as NOw()).
• Missing VALUES keyword in INSERT statements.

How to Fix It

1. Read the error location carefully

-- MySQL shows where the parser stopped:
-- 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 'FROM users' at line 2

The quoted snippet 'FROM users' is the problem zone.

2. Check for missing commas

-- Wrong
SELECT id name FROM users;

-- Correct
SELECT id, name FROM users;

-- Wrong
INSERT INTO users (id name) VALUES (1 'John');

-- Correct
INSERT INTO users (id, name) VALUES (1, 'John');

3. Match quotes and parentheses

-- Wrong (unclosed string)
WHERE name = 'John;

-- Correct
WHERE name = 'John';

-- Wrong (unbalanced parens)
WHERE id IN (1, 2, 3;

-- Correct
WHERE id IN (1, 2, 3);

4. Quote reserved words with backticks

-- Wrong
SELECT * FROM order;

-- Correct
SELECT * FROM `order`;

Common reserved words: GROUP, ORDER, SELECT, WHERE, TABLE, INDEX, KEY, DEFAULT, CHECK.

5. Verify function names

-- Wrong
SELECT NOw();

-- Correct
SELECT NOW();

-- Wrong
SELECT COUNT id FROM users;

-- Correct
SELECT COUNT(id) FROM users;

FAQ