CREATE DATABASE
New, and
Syntax
CREATE DATABASE [IF NOT EXISTS] db_name [CHARACTER SET charset] [COLLATE collation];
Parameters
| Parameters | Description | Examples | Level |
|---|---|---|---|
IF NOT EXISTS |
CREATE DATABASE IF NOT EXISTS mydb; |
Common | |
CHARACTER SET |
CREATE DATABASE mydb CHARACTER SET utf8mb4; |
Common | |
COLLATE |
CREATE DATABASE mydb COLLATE utf8mb4_unicode_ci; |
Common | |
DROP DATABASE |
DROP DATABASE IF EXISTS test_db; |
||
SHOW DATABASES |
SHOW DATABASES; |
Common |
Examples
CREATE DATABASE IF NOT EXISTS ecommerce CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
utf8mb4 emoji and more 4
SHOW DATABASES; USE ecommerce;
USE
SHOW CREATE DATABASE ecommerce;
and
DROP DATABASE IF EXISTS test_db;
, and
Common Errors
ERROR 1007 (HY000): Can't create database 'mydb'; database exists, IF NOT EXISTS
ERROR 1044 (42000): Access denied for user, GRANT CREATE
Tips
- utf8mb4, utf8( 3 )
- utf8mb4_unicode_ci() utf8mb4_bin()