SQL 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 -
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.
These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.
These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.
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...