mysql create database incorrect name

Question

For example, when I go to the mysql command line and do:

mysql> create database `#mysql#testdb`;

and try:

mysql> show databases;

I only get a db named "testdb" and NOT "#mysql#testdb".

Any idea what's wrong here?

Gabriel L. · Accepted Answer · 2013-10-10 18:42:39Z

3

You use special characters like # (sql comments). If you can avoid it, use the underscore '_' instead of #. Otherwise, look at this page, it should help you to use the special characters.

answered Oct 10, 2013 at 18:42

Gabriel L.

5,0645 gold badges30 silver badges34 bronze badges

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

Comments

Snowburnt · Accepted Answer · 2013-10-10 18:44:18Z

2

# is a mysql comment notation. you're commenting out the mysql, basically.

answered Oct 10, 2013 at 18:44

Snowburnt

6,9558 gold badges33 silver badges44 bronze badges

Collectives™ on Stack Overflow

mysql create database incorrect name

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