对DML的不同响应可能有助于研究dbt, dbt是一种广泛使用的用于部署数据转换的开源工具。(详情请点击这里。)

dbt方便“选择”语句，但不方便其他DML命令。看,如。“为什么我不能在转换中直接写DML ?”

简单地说。

DDL(数据定义语言):将工作在数据结构上。定义数据结构。

DML(数据操作语言):将工作在数据上。操作数据本身

DDL =数据定义语言，提供数据结构和其他信息的任何命令

DML =数据操作语言，只有3个，插入，更新，删除。4，如果你将SELECT * INTO x_tbl from tbl的MSSQL (ANSI SQL:创建表x_tbl AS SELECT * from tbl)

什么是DDL, DML和DCL?：

DDL DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database. CREATE – to create database and its objects like (table, index, views, store procedure, function and triggers). ALTER – alters the structure of the existing database. DROP – delete objects from the database. TRUNCATE – remove all records from a table; also, all spaces allocated for the records are removed. COMMENT – add comments to the data dictionary. RENAME – rename an object. DML DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database. SELECT – retrieve data from one or more tables. INSERT – insert data into a table. UPDATE – updates existing data within a table. DELETE – delete all records from a table. MERGE – UPSERT operation (insert or update) CALL – call a PL/SQL or Java subprogram. EXPLAIN PLAN – interpretation of the data access path. LOCK TABLE – concurrency control. DCL DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system. GRANT – allow users access privileges to database. REVOKE – withdraw users access privileges given by using the GRANT command. TCL TCL is short name of Transaction Control Language which deals with transaction within a database. COMMIT – commits a transaction. ROLLBACK – rollback a transaction in case of any error occurs. SAVEPOINT – a point inside a transaction that allows rollback state to what it was at the time of the savepoint. SET TRANSACTION – specify characteristics for the transaction.

DDL代表数据定义语言。DDL用于定义表的结构，如创建表或向表中添加列，甚至删除和截断表。 DML代表数据操作语言。顾名思义，DML是用来操作表中的数据的。DML中有一些命令，如插入和删除。

DDL:更改模式

DML:更改数据

似乎特定于MySQL的限制(rails的源代码)