4 Major SQL command categories
July 05,2012 Read: 551 TimesSQL commands are the instructions that used to communicate with the database and perform specific task for manipulating data. SQL commands can be used for creating tables, adding data to tables, or modifying data, dropping the tables, searching data from tables, set authentication for users.
In this tutorial we learn about four major categories of MySQL commands depending according to their functionality. Let’s go -
- Data Definition Language (DDL):
We are using these SQL commands for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.
- Data Manipulation Language (DML):
These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.
- Transaction Control Language (TCL):
These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.
- Data Control Language (DCL):
These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.
In upcoming tutorial we learn more details about each commands of SQL. Subscribe our RSS Feed to get notfication of tutorial.
Was this information useful? What other tips would you like to read about in the future? Share your comments, feedback and experiences with us by commenting below!
You might also like...
Author: Md Mahbub Alam Khan (255 Posts)
Md Mahbub Alam Khan is the Editor and Founder of CoolAJAX Web Blog. You can follow CoolAJAX on Twitter , on Facebook or you can subscribe via RSS .
Topics
