Before we delve into the definition of MySQL, let's first discuss RDBMS (Relational Database Management System).
An RDBMS stores data in a collection of tables that are linked together through common fields present in the table columns. Additionally, it offers relational operators to effectively handle the data stored within these tables. Now, MySQL stands as a distinctive implementation of an RDBMS, serving as an open-source database system widely renowned for its efficacy in database creation and management. MySQL adheres to the SQL standard and incorporates supplementary features and optimizations unique to its implementation.
SQL (Structured Query Language) represents a standardized language specifically designed for the management and manipulation of relational databases.
MySQL commands are specific statements or instructions that are used to interact with the MySQL database system. These commands are executed within the MySQL command-line interface (CLI) or through a graphical user interface (GUI) tool.
DDL: Stands for data defined langauge and these commands are used to define and manage the structure of database objects. They are primarily focused on creating, modifying, and deleting database objects such as tables, indexes,
- Create.
- Alter.
- Drop.
- Truncate.
- Rename.
DML: Stands for data manipulation language and these commands are used to manipulate the data stored within the table.
- Select.
- Insert
- Update
- Delete
DCL: Stands for data control language and these commands are used to control access and permissions within the database.
- Grant
- Revoke
TCL: Stands for transaction control language and these commands are used to manage transactions within the database. They allow control over the changes made to the database and enable transactions to be committed or rolled back.
- Commit
- Rollback
- Savepoint
- Set Transaction
