W
W
Worddoc2016-07-04 09:06:43
MySQL
Worddoc, 2016-07-04 09:06:43

1064 MySQL error when trying to create a database!?

Hello. I just started learning SQL and MySQL from video tutorials, so when I try to create a database: CREATE newDataBase; Throws 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 'newDataBase' at line 1.
I searched in previous topics, different commands cause such errors for everyone, I can't understand why ... Help?)

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Alexander Kosarev, 2016-07-04
@Worddoc

1064 indicates the use of reserved words as database elements or an error in the query structure. And so - SQL-query in studio.

D
Dmitry Kovalsky, 2016-07-04
@dmitryKovalskiy

Excuse me, but how will your server guess what you are actually creating? Table, trigger, view, base.

V
Vlad Zhivotnev, 2016-07-04
@inkvizitor68sl

Bases with backtit are created.
create `blabla`;

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question