Is it possible to create a database under database in MySQL?

Question

Apologies if im mistaken.

I'm newbie to MySQL and using phpMyAdmin as GUI tool.

I wonder if I can create a database under database for hierarchical structure.

For now, I can only create tables under a database.

If it's impossible what are the alternatives for hierarchical databases?

The alternatives depend on what you want to do. You can create several databases in parallel. Or, what many applications do to support accounts which grant only a single database to a user (typical for cheap web hosters), you use a fixed prefix string for your tables. That way you can at least "group" the tables. — arkascha
– arkascha, Commented Jun 27, 2015 at 13:05

Mureinik · Accepted Answer · 2015-06-27 13:01:36Z

1

Short answer: No. You cannot create a database inside another database.

answered Jun 27, 2015 at 13:01

Mureinik

316k54 gold badges402 silver badges406 bronze badges

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

1 Answer 1