MySQL language classification and data submission type

• Language classification

1>, DDL (Data Definition Language)

A data definition language that defines and manages all objects in a database. Example: Create, Alter, Drop.

2>, DML (Data munipulation Language)

A data manipulation language used to process data. For example: Insert, Delete, Update, Select.

3>, DCL (Data Control Language)

Data Control language, which is used for privileged control, controlling the time and effect of database transaction, monitoring database and so on. For example: Grant, Commit, Rollback.

• Data submission Type

1>, Explicit commit

Commit with Commit.

2>, implicit submission

When using SQL command time to submit, such as: Alter FUNCTION, ALTER PROCEDURE, Alter TABLE, BEGIN, CreateDatabase, create FUNCTION, create INDEX, create PROCEDURE, CreateTable, drop DATABASE, drop FUNCTION, drop INDEX, drop Procedure,drop table, LOAD MASTER DATA, LOCK table S, RENAME table, Setautocommit=1, START TRANSACTION, TRUNCATE table, UNLOCK TABLES.

3>, Auto-submit

After performing set autocommit on, the system commits automatically after the insert, DELETE, and update are executed.

• Instructions for use

1>, all DML statements are explicitly committed, meaning that a commit is executed after the DML statement is executed;

2>, while others, such as DDL statements, are implicitly committed. In other words, after running those non-DML statements, the database has been implicitly committed, such as CreateTable, after running the script, the table has been built, and do not need you to explicitly commit;

3>, the transaction can be rolled back with rollback before committing the transaction (commit).

MySQL language classification and data submission type