MySQL returns the database name and the character set and collation of the database: +-+-+ 02 sec) Code language: CSS ( css )Īfter that, use the SHOW CREATE DATABASE command to review the created database: SHOW CREATE DATABASE testdb Code language: SQL (Structured Query Language) ( sql ) It’ll return the following: Query OK, 1 row affected (0. Then, issue the CREATE DATABASE command with a database name e.g., testdb and press Enter: CREATE DATABASE testdb SHOW DATABASES ĥ rows in set (0.00 sec) Code language: JavaScript ( javascript ) Next, display the current databases available on the server using the SHOW DATABASES statement. To authenticate, you need to type the password for the root user account and press the Enter key. It’ll prompt you for entering a password. To create a new database via the mysql client tool, you follow these steps:įirst, log in to the MySQL Server using a user account that has the CREATE DATABASE privilege: mysql -u root -p Code language: SQL (Structured Query Language) ( sql ) If you skip the CHARACTER SET and COLLATE clauses, MySQL will the default character set and collation for the new database.Ĭreating a new database using the mysql client tool Third, specify the character set and collation for the new database.Second, use the IF NOT EXISTS option to conditionally create a database if it doesn’t exist.If you attempt to create a database with a name that already exists, MySQL will issue an error. The database name must be unique within a MySQL server instance. First, specify name of the database after the the CREATE DATABASE keywords.Code language: SQL (Structured Query Language) ( sql ) To create a new database in MySQL, you use the CREATE DATABASE statement with the following syntax: CREATE DATABASE database_name Introduction to the MySQL CREATE DATABASE statement Summary: in this tutorial, you will learn how to use the MySQL CREATE DATABASE statement to create a new database on a MySQL database server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |