How do I create a schema in mysql?



How do I create a schema in mysql?..

Answer / Pooja Vishwakarma

A schema in MySQL is essentially a container for databases. Since you can only have one schema, it's not necessary to explicitly create a schema as all your databases will be created within the default schema. However, if you want to use an alternative schema name, you can do so when creating the database with the `CREATE DATABASE` command: `CREATE SCHEMA <schema_name>; CREATE DATABASE <database_name> DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to delete a trigger in mysql?

1 Answers  


How can I create a database in mysql?

1 Answers  


What is the current version of mysql?

1 Answers  


What causes mysql too many connections?

1 Answers  


Does uninstalling mysql delete database?

1 Answers  


What are mysql queries?

1 Answers  


What is mysqli_num?

1 Answers  


Is mysql a database?

1 Answers  


What is ndb in mysql?

1 Answers  


What is mysql enterprise edition?

1 Answers  


How to find second highest salary from a table?

1 Answers  


Why do we use preparedstatement?

1 Answers  


Categories