Data Manipulation in MySQL
Structured Query Language, or SQL, is the standard language use to communicate with a database to add, modify, delete records and data retrieval(selection) used by all the RDBMS. So, in this article, we will see what is data manipulation in mysql.
SQL statements fall into one of three categories:
1. Data Definition Language(DDL) :
DDL consists of statements that define the structure and relationships of a database and its tables, Typically, these statements are use to create, delete, and modify databases and tables; specify field names and types; and set indexes.
2. Data Manipulation Language(DML):
DML statements are relate to altering and extracting data from a database. These statements are use to add records from, a database; perform queries; retrieve table records matching one or more user-specify criteria; and join tables together using their common fields.
3. Data Control Language(DCL) :
DCL statements are used to define access levels and security privileges for a database. We would use these statements to grant or deny user privileges; assign roles; change passwords; view permissions; and create rulesets to protect access to data.
SQL queries are similar to English statements. The syntax is very simple; every SQL statement begins with an “action word,” like DELETE, INSERT, ALTER or CREATE, and ends with a semicolon. Whitespace, tabs, and carriage returns are ignored.
