SQL 数据库关键字
CREATE DATABASE
The CREATE DATABASE
command is used is to create a new SQL database.
The following SQL creates a database called "testDB"
示例
CREATE DATABASE testDB;
Tip: Make sure you have admin privilege before creating any database. Once a database is created, you can check it in the list of databases with the following SQL command: SHOW DATABASES;
DROP DATABASE
The DROP DATABASE
command is used is to delete an existing SQL database。
The following SQL drops a database named "testDB" (以下 SQL 语句删除名为 "testDB" 的数据库)
示例
DROP DATABASE testDB;
Note: Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database! (注意:删除数据库前请务必小心。删除数据库将导致其中存储的所有信息丢失!)