诛仙青云门长老:SQL 中 DDL, DML, DCL 和 TCL
来源:百度文库 编辑:九乡新闻网 时间:2024/04/29 11:39:57
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
SQL 中 DDL, DML, DCL 和 TCL
DCL
SQL Server 2008中的代码安全(二):DDL触发器与登录触发器 - 邀月工作室 - 博客园
php中implode函数和sql中的in的配合使用-一叶随风飘-ZOL博客
SQL Server 2008中通过DBCC OPENTRAN和会话查询事务 - 邀月工作室 - 博客园
SQL中IN,NOT IN,EXISTS,NOT EXISTS的用法和差别
尽量在SQL中Group
SQL
winform 获取局域网中SQL SERVER服务器
如何在PL/SQL中读写文件
asp.net 中SQL备份还原
SQL 过程的性能: 提示和技巧
SQL Server 2005 中的分区表和索引
SQL Server 2008中SQL之WaitFor - 邀月工作室 - 博客园
SQL Server 2008中SQL应用之-“死锁(Deadlocking)” - 邀月工作室 - 博客园
《SQL Server 2005范例代码查询辞典(SQL Server程序员和DBA不可或...
sql server2005 存储数据库表名、字段名、描述的数据库表和sql语句
SQL Server 2005 安装教程_中jjkhlkkljlkjkljlkjj
Oracle中捕获问题SQL解决CPU过渡消耗
SQL Server中访问Oracle服务器的方法
Java/JSP中使用JDBC连接SQL Server 2005
TCL重大内幕是可能爆发的收购战和抱团取暖市场选择
TCL人才战略思考:鹰是训练和激励出来的
Sql Server删除主键和重建主键 - 编程 - CSDN博客