So, you can buy a commercial license version from Oracle to get premium support services.įig 1: Features of MySQL – What is MySQL? It provides multi-user access to support many storage engines and is backed by Oracle. MySQL is an open-source relational database management system that works on many platforms. Example – Commit, Rollback, Savepoint, Set Transaction.Īlright! So, now that you know SQL, it’s time I introduce to MySQL. TCL (Transaction Control Language) – It allows you to deal with the transaction of the database.Example – Grant or Revoke access permissions. DCL (Data Control Language) – It allows you to control access to the database.It helps you to insert, update, delete and retrieve data from the database. DML (Data Manipulation Language) – It allows you to access and manipulate data.DDL (Data Definition Language) – It allows you to perform various operations on the database such as CREATE, ALTER and DELETE objects.The different subsets of SQL are as follows: ![]() By using SQL, you can add, update or delete rows of data, retrieve subsets of information, modify databases and perform many actions. SQL is the core of a relational database which is used for accessing and managing the database. Now, that I have told you about DBMS, it’s time that we understand what is SQL? Each object contains a piece of data, and the instructions for the actions to be done with the data.
0 Comments
Leave a Reply. |