Course Content
MySQL Editions
MySQL Editions
0/1
MySQL Database Structure
MySQL Database Structure
0/1
MySQL Components
MySQL Components
0/1
MySQL Tools
MySQL Tools
0/1
MySQL Data Types
MySQL Data Types
0/1
MySQL Storage Engines
MySQL Storage Engines
0/1
Create MySQL Database
Create MySQL Database
0/1
MySQL Create Table
MySQL Create Table
0/1
MySQL INSERT Statement
MySQL INSERT Statement
0/1
MySQL SELECT Statement
MySQL SELECT Statement
0/1
MySQL UPDATE Statement
MySQL UPDATE Statement
0/1
MySQL DELETE Statement
MySQL DELETE Statement
0/1
MySQL DROP Database
MySQL DROP Database
0/1
MySQL Functions
MySQL Functions
0/1
MySQL CREATE VIEW
MySQL CREATE VIEW
0/1
MySQL DROP Table
MySQL DROP Table
0/1
MySQL GROUP BY Clause
MySQL GROUP BY Clause
0/1
MySQL Replace Statement
MySQL Replace Statement
0/1
MySQL Subquery
MySQL Subquery
0/1
MySQL Joins
MySQL Joins
0/1
MySQL Import/Export
MySQL Import/Export
0/2
MySQL Beginner
About Lesson

DELETE Statement

The MySQL DELETE Statement is used to remove records from a table in a database. This statement allows you to delete specific rows or all rows based on specified
conditions.

Syntax

The general syntax of the MySQL delete statement is as follows:

DELETE FROM table_name
WHERE condition;

table_name: The name of the table where you want to delete data.
condition: Specifies which rows should be deleted. If omitted, all rows in the table will be deleted.

Â