Mysql-based DML, DDL, DCL definitions

I. DML

Data manipulation language (manipulation Language, DML) is a set of instructions in the SQL language that is responsible for running data access to database objects, with the INSERT, UPDATE, delete three directives as the core, representing inserts, updates, and deletions, respectively. is to develop the instructions that the data-centric application must use,

Main command:

Insert, UPDATE, deleteselect column name from table name UPDATE table name SET column name = new value WHERE Column name = value INSERT INTO table_name (column 1, column 2,...) Values (value 1, value 2,....) DELETE from table name WHERE column name = value

Ii. DDL (data definition language)

The database Schema definition language DDL (Data definition Language) is the language used to describe the real-world entities to be stored in the database.

Common commands:

  create,        CREATE DATABASE        create function       create function udf        create index       create  PROCEDURE       CREATE TABLE        CREATE TRIGGER       CREATE USER        CREATE VIEW       SHOW        SHOW CREATE DATABASE       SHOW CREATE  function       show create procedure        show create table       spatial  drop        alter table       deallocate prepare        DROP DATABASE       DROP FUNCTION        drop function udf       drop  INDEX       DROP PROCEDURE        DROP TABLE       DROP TRIGGER        DROP USER       DROP VIEW  ALTER     topics:   ALTER DATABASE   ALTER FUNCTION    ALTER PROCEDURE   ALTER TABLE   ALTER VIEW    grant   spatial

Iii. DCL (Data Control Language)

The DCL (Data Control Language) is a database control language. is a statement that is used to set or change permissions for a database user or role, including (Grant,deny,revoke, etc.) statements. By default, only people such as Sysadmin,dbcreator,db_owner or db_securityadmin have the power to execute the DCL

Eg: Create a user for the dbname library and give all permissions grant all on dbname.* to ' user1 ' @ ' 192.168.12.9 ' identified by ' password ';

Mysql-based DML, DDL, DCL definitions