database name in mysql seems valid but it is showing an error

Question

I am trying to create a database with a '-' in between two words and it should work perfectly fine but it isn't. here is the log file:

mysql> create database test1;
Query OK, 1 row affected (0.00 sec)

mysql> show databases
    -> ;
+-----------------------+
| Database              |
+-----------------------+
| information_schema    |
| mifos                 |
| mifosplatform_tenants |
| mifostenant           |
| mifostenant_default   |
| mysql                 |
| performance_schema    |
| sakila                |
| test                  |
| test1                 |
| testing               |
| world                 |
+-----------------------+
12 rows in set (0.00 sec)

mysql> create database test1-mohit;
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 '-mohi
t' at line 1

can not use of hyphen in database name

Esha Garg
– Esha Garg

2013-04-20 04:11:32 +00:00
Commented Apr 20, 2013 at 4:11 — Esha Garg
– Esha Garg, Commented Apr 20, 2013 at 4:11

PSR · Accepted Answer · 2013-04-20 04:05:07Z

1

you can use _(underscore)

create database test1_mohit;

or try this

  create database `test1_mohit`;

These both will work

answered Apr 20, 2013 at 4:05

PSR

40.4k43 gold badges115 silver badges154 bronze badges

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

Comments

Tamil Selvan C · Accepted Answer · 2013-04-20 04:06:30Z

0

Use one of these character for naming database [0-9,a-z,A-Z$_]

Reference: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

answered Apr 20, 2013 at 4:06

Tamil Selvan C

20.3k12 gold badges55 silver badges72 bronze badges

Collectives™ on Stack Overflow

database name in mysql seems valid but it is showing an error

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