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

The following is the notes on the cloud computing learning route source framework, and the following is about the second part of the Mysql source code:

SQL statement classification:

SQL statements are mainly divided into three categories.

DDL statement

DDL is a data definition statement, which is used to create, delete, modify and other operations on objects within the database. Create, drop, alter, etc. (commonly used in DBA)

DML statement

DML is a data operation statement, which refers to the basic operation of database table records, such as insert, update, delete, select, etc. (commonly used in development)

DCL statement

DCL is a data control statement that controls the direct permission and access levels of different data segments. Define the access rights and security levels of databases, tables, fields, users. Mainly grant, revoke, etc. (commonly used in DBA)

Basic operation of database

Addition, deletion, modification and query of the database

Library operation

Create a library

Mysql > create database db1

View the library

Mysql > show databases

Mysql > show create database db1; / / View the library in more detail

Use the library

Mysql > use db1

Paragraph'=''

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.