1. DDL
-
1.11 概念:数据定义语言,用于定义和管理 SQL 数据库中的所有对象的语言
-
1.12 常用命令:
-
a. CREATE - to create objects in the database 创建
-
b. ALTER - alters the structure of the database 修改
-
c. DROP - delete objects from the database 删除
-
d. TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
2. DML
-
2.11 概念:数据操作语言,SQL中处理数据等操作统称为数据操纵语言
-
2.12 常用命令:
-
a. SELECT - retrieve data from the a database 查询
-
b. INSERT - insert data into a table 添加
-
c. UPDATE - updates existing data within a table 更新
-
d. DELETE - deletes all records from a table, the space for the records remain 删除
-
e. CALL - call a PL/SQL or Java subprogram
-
f. EXPLAIN PLAN - explain access path to data
1.DDL
1.13 数据库的操作
-
创建数据库