MySQL DML Commands

Introduction

Data Manipulation Language (DML) commands in MySQL are used to manipulate and manage data within tables. They allow you to insert, retrieve, update, and delete data. In this article, we will explore the commonly used DML commands in MySQL and provide examples to illustrate their usage.

INSERT INTO

The INSERT INTO command is used to add new records (rows) to a table. Here's an example:

INSERT INTO customers (name, email) VALUES ('John Doe', 'john.doe@example.com');

SELECT

The SELECT command is used to retrieve data from one or more tables. Here's an example:

SELECT * FROM products;

UPDATE

The UPDATE command is used to modify existing data in a table. Here's an example:

UPDATE employees SET salary = 50000 WHERE id = 1;

DELETE

The DELETE command is used to remove records from a table. Here's an example:

DELETE FROM customers WHERE id = 2;

WHERE Clause

The WHERE clause is used to add conditions to the SELECT, UPDATE, and DELETE commands. It allows you to filter data based on specific criteria. Here's an example:

SELECT * FROM orders WHERE total_amount > 1000;

ORDER BY Clause

The ORDER BY clause is used to sort the result set in ascending or descending order. Here's an example:

SELECT * FROM products ORDER BY price DESC;

LIMIT Clause

The LIMIT clause is used to limit the number of rows returned by a SELECT statement. It is often used with the ORDER BY clause. Here's an example:

SELECT * FROM customers ORDER BY registration_date DESC LIMIT 10;

Conclusion

MySQL DML commands are essential for manipulating and managing data within tables. In this article, we explored the INSERT INTO, SELECT, UPDATE, and DELETE commands, along with the WHERE, ORDER BY, and LIMIT clauses. By mastering these commands, you can efficiently insert, retrieve, update, and delete data in your MySQL databases, making it easier to work with and manage your data effectively.