Скачать или смотреть Database Systems - How to create a Database - CREATE DATABASE Statement

You can create a new database with the CREATE DATABASE statement. After creating a database, that is when you can start adding tables to it. To delete a database, use the DROP DATABASE statement, which also deletes all tables in that database.

Examples:
CREATE DATABASE movies;
CREATE DATABASE albums;
DROP DATABASE movies;

The SHOW statement shows the database developer some useful information about your database tables and columns.

Examples:

SHOW DATABASES – lists all available databases. You can choose which database to use with the USE statement. Ex: Use albums;
SHOW TABLES – lists all tables in the database you are currently using
SHOW COLUMNS FROM tableName – lists all the columns of a table, where tableName is the name of the table
SHOW CREATE TABLE – shows the CREATE TABLE statement used to create the table

The USE statement selects a database

Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!