CREATE SCHEMA is a synonym for CREATE DATABASE. To use this statement, you need the CREATE privilege for the database. # mysql -u root -pMySecretPWDĬREATE DATABASE creates a database with the given name. In a typical situation, you’ll login to mysql as root and execute the above create database command. Please note that only users who have the CREATE privilege for the database can execute the above commands. The following command is exactly same as the above create database. Create schema is nothing but a synonym for Create database. But in MySQL and MariaDB world, it is really called and referred as “database” instead of “schema”.īut for some reason, if you prefer, you can also use the following “create schema” command to create a database. When we are creating a “database” in the MySQL, we are actually creating a “schema”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |