Unable to create a simple database in mySQL

Question

CREATE DATABASE 'hello' ;

19:40:38 CREATE DATABASE 'hello' Error Code: 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 ''hello'' at line 1

I installed mysql with default settings and I don't know if it has anything to do with the settings.

Can someone tell me how to fix this error?

'hello' is a string literal. Identifiers are not quoted in SQL. Details are in the manual: dev.mysql.com/doc/refman/5.5/en/identifiers.html — user330315
– user330315, Commented Nov 18, 2014 at 14:21
If you must quote the database name, then use back ticks ` — Peter
– Peter, Commented Nov 18, 2014 at 14:24

SDK · Accepted Answer · 2014-11-18 14:23:41Z

1

Basic syntax of CREATE DATABASE statement is as follows:

        CREATE DATABASE DatabaseName;

Try Like Below...

        CREATE DATABASE hello;

answered Nov 18, 2014 at 14:23

SDK

1,5421 gold badge17 silver badges31 bronze badges

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

Comments

Semih Eker · Accepted Answer · 2014-11-18 14:24:07Z

0

Use like this;

 CREATE DATABASE hello;

http://dev.mysql.com/doc/refman/5.0/en/create-database.html

answered Nov 18, 2014 at 14:24

Semih Eker

2,4071 gold badge21 silver badges29 bronze badges

Collectives™ on Stack Overflow

Unable to create a simple database in mySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related