SQL statement 1 Create and view Databases

SQL statements can be divided into three types: DML (DataManipulationLanguage) data operation language |-used to retrieve and modify data DDL (DataDefinitionLanguage) data Definition Language |-used to create, modify, and delete database objects (tables, relationships, indexes, and views). DataControlLanguage

SQL statements can be divided into three types: DML (Data Manipulation Language) Data operation Language |-used to retrieve and modify Data DDL (DataDefinition Language) data Definition Language |-used to create, modify, and delete database objects (tables, relationships, indexes, and views). Data Control Language (DLC)

SQL statements can be divided into the following three types:

DML (Data Manipulation Language) Data operation Language

|-Used to retrieve and modify data

DDL (DataDefinition Language) Data Definition Language

|-Used to create, modify, and delete database objects (tables, relationships, indexes, and views)

Data Control Language (DLC)

|-Defines Database User Permissions (Database Management)

Database creation:

Create database db_name

Default character set UTF-8;

Database View:

Show databases;

Database usage:

Use db_name;

Delete database:

Drop database if exists db_name;