SQL
These are the main categories are
DDL(Data Definition Language)
DML ( Data Manipulation Language)
DQL( Data Query Language)
DCL( Data control Language)
Data administration commands
Transactional control command.
ddl includes insert ,delete ,update values
it include select statements,
it include insert statement,
it includes drop statements
data manipulation language, belongs to databases and sql. queries like insert/update/delete. in contrast, queries like create/alter/drop are called ddl (data definition language)
DML is a Doctor of Modern Languages.
ddl stands for Data Definaton Language.Eg:- Create ,Alter .Drop.Truncate Why we have called it as DDL means.... we are defining or acting at structure level. Say, when ever you create a table we are dealing at strucutre level. Hence its is DDL
DDL statements -Data Definition Language It is used to Retrive,Store,Modify,Delete,Insert,update data in database. 1) Create 2) Alter 3) Drop DML Statements.-Data Manipulation Languag It is used to create and modify the structure of database objects in database. 1) Insert 2) Update 3) Delete 4) select DCL statements-Data Control Language It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. 1) GRANT 2) REVOKE TCL-Transactional Control Language It is used to manage different transactions occurring within a database. 1) COMMIT 2) ROLLBACK 3) Save point DQL-Data Query Language basicallu used for select data from table... 1) SELECT
Retrieving Data,Inserting Data,and Deleting Data.
DML
The basic difference between DDL and DML is the commands they provide . The DDL provides statement for the creation and deletion of tables, indexes, views etc. while the DML provides statements to enter, update, delete and perform complex queries on these tables.
ddl: data definition languagedml: data manipulation language
The differences between them you can get from, http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html
Details is discussed on http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html
The DDL provides statement for the creation and deletion of tables, indexes, views etc. The DML provides statements to enter, update, delete and perform complex queries on these tables.
The basic difference between DDL and DML is the commands they provide . The dml (data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables while the ddl(data description language) provides statement for the creation and deletion of tables, indexes, views etc.
DML(data manipulation language) provides statements to enter, update, delete and perform complex queries on these tables. DDL(Data definition language) provides statements for creation and deletion of tables, view, indexes etc.
Data Definition Lenguage (DDL) Data Manipulation Lenguage (DML) Data Dictionary
Data manipulation language(DML) data Defenition language(DDL) data control Language(DCL) Transaction Control
DDL Statments
It is not C, it's SQL. Non-query means DML (INSERT, UPDATE, DELETE) and DDL (eg CREATE TABLE).