数据库中的DML,DCL,DDL分别是那些操作?
来源:互联网 发布:如何加入淘宝 编辑:程序博客网 时间:2024/05/01 04:17
原文地址:http://liyuan2005.iteye.com/blog/209218
DDL
Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:
- CREATE - to create objects in the database
- ALTER - alters the structure of the database
- DROP - delete objects from the database
- TRUNCATE - remove all records from a table, including all - spaces allocated for the records are removed
- COMMENT - add comments to the data dictionary
- RENAME - rename an object
DML
Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:
- SELECT - retrieve data from the a database
- INSERT - insert data into a table
- UPDATE - updates existing data within a table
- DELETE - deletes all records from a table, the space for the records remain
- MERGE - UPSERT operation (insert or update)
- CALL - call a PL/SQL or Java subprogram
- EXPLAIN PLAN - explain access path to data
- LOCK TABLE - control concurrency
DCL
Data Control Language (DCL) statements. Some examples:
- GRANT - gives user’s access privileges to database
- REVOKE - withdraw access privileges given with the GRANT command
TCL
Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.
- COMMIT - save work done
- SAVEPOINT - identify a point in a transaction to which you can later roll back
- ROLLBACK - restore database to original since the last COMMIT
- SET TRANSACTION - Change transaction options like isolation level and what rollback segment to use
0 0
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML,DCL,DDL分别是那些操作?
- 数据库中的DML、DDL、DCL区别
- 数据库: DML、DDL、DCL
- 数据库 DDL","DML","DCL"
- SQL中的DML,DDL,DCL分别表示的是什么
- 数据库DDL、DML和DCL
- 数据库DDL,DML,DCL,TCL
- 数据库DML、DDL、DCL区别
- DML、DDL、DCL三者定义(数据库的操作)
- 数据库操作语句类型(DQL、DML、DDL、DCL)简介
- 数据库操作语句类型(DQL、DML、DDL、DCL)简介
- 操作CString 对象出错 未RealeaseBuffer
- Notification自定义Layout(大视图)
- Android Hook Java的的一个改进版本
- 筛选数据函数
- YTU 2577: 小数计算——结构体
- 数据库中的DML,DCL,DDL分别是那些操作?
- Android中的SQLite数据库存储
- ASP.NET 4.5 MVC 4 无法在Windows2008的IIS7.0上解决方案
- 深入浅出 React Native:使用 JavaScript 构建原生应用
- 程序员健康指南--努力健康起来吧
- 如何debug Network Extension
- 进击的Android Hook 注入术《一》
- Qualcomm即将发布Vulkan支持版本Adreno
- Android 学习 2016.3.7