Shulou(Shulou.com)06/01 Report--

DML (Data Manipulation Language, data manipulation language): used to retrieve or modify data.

DML includes: SELECT: used to retrieve data

INSERT: used to add data to the database

UPDATE: used to modify existing data from the database

DELETE: used to delete data from the database.

DDL (Data Definition Language, data definition language): used to define the structure of data, such as creating, modifying, or deleting database objects.

DDL includes: DDL statements can be used to create users and rebuild database objects. Here is the DDL command:

CREATE TABLE: creating tables

ALTER TABLE

DROP TABLE: deleting tables

CREATE INDEX

DROP INDEX

DCL (Data Control Language, data control language): used to define the permissions of database users.

DCL includes:

ALTER PASSWORD

GRANT

REVOKE

CREATE SYNONYM

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.