MySQL Database operations

1 syntax (help CREATE DATABASE)

CREATE database name CharSet UTF8;

2 Database naming rules:

can be by letter, number, underscore, @, #, $ case-sensitive uniqueness cannot use keywords such as create select cannot use the number maximum 128 bits alone

Two database related operations

1 View the database show databases;show CREATE DATABASE Db1;select database (); 2 Select the databases use database name 3 Delete database Dorp database name; 4 Modify database Alter DAT Abase DB1 CharSet UTF8;

MySQL Database operations