MySQL Error Code: 1064. You have an error in your SQL syntax

Question

Really, what could possibly be wrong?! It does not get any more simple - the entire query:

line 1: use foo
line 2: 
line 3: select * from test_table_1;

Error Code:

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 'select * from test_table_1' at line 3 0.002 sec

The line numbers are for reference only - there not actually in the query window.

I'm trying to run this extremely simple query in MySQLWorkbench and it's throwing a syntax error.

musical_coder · Accepted Answer · 2013-11-06 00:01:42Z

5

Try adding a semicolon:

use foo;

answered Nov 6, 2013 at 0:01

musical_coder

3,8963 gold badges17 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ken White Over a year ago

This would be a much better answer if you explained why a semicolon is needed, instead of just "Try adding". "Try adding" is a suggestion, not an answer. :)

Roy Hinkley Over a year ago

Gracias! that's the missing link. I keep forgetting that MySQL is very particular about the semicolon. My bad habits :^)

Hafiz Arslan · Accepted Answer · 2015-09-17 07:29:50Z

0

Without semicolon both statements will treat as single one. By adding semicolon MySQL will treat both statements as multiple queries. Try using

 use foo;
    /*and then*/
    select * from foo;

answered Sep 17, 2015 at 7:29

Hafiz Arslan

4735 silver badges16 bronze badges

Collectives™ on Stack Overflow

MySQL Error Code: 1064. You have an error in your SQL syntax

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related