phpeveryday.com

If you work with database, you always work with SQL (Structure Query Language). One common method used to categorized SQL statements is to devide them according to the functions they perform. Based on this method, SQL can be separated into three types of statements:

Data Definition Language (DDL) DDL statements are used to create, modify, or delete database object such as tables, views, schemas, domains, triggers, and stored procedures. The SQL keywords most often associated with DDL statements are: CREATE, ALTER, and DROP.

Data Control Language DCL statement allow you to control who has access to specific object in your database. With the DCL statements, you can grant or restrict access by using the GRANT or REVOKE statements.

Data Manipulation Language DML statements are used to view, add, modify, or delete data stored in your database objects. The primary keywords associated with DML statement are SELECT, INSERT, UPDATE, and DELETE.