• Home
  • Jobs
  • Courses
  • Certifications
  • Companies
  • Online IDE
  • Login
  • Signup
MySQL
  • Introduction To MySQL
  • MySQL RDBMS
  • MySQL SQL
  • MySQL SELECT Statement
  • MySQL WHERE Clause
  • MySQL AND, OR And NOT Operators
  • MySQL ORDER BY Keyword
  • MySQL INSERT INTO Statement
  • MySQL NULL Values
  • MySQL UPDATE Statement
  • MySQL DELETE Statement
  • MySQL LIMIT Clause
  • MySQL MIN() And MAX() Functions
  • MySQL COUNT(), AVG() And SUM() Functions
  • MySQL LIKE Operator
  • MySQL Wildcards
  • MySQL IN Operator
  • MySQL BETWEEN
  • MySQL Aliases
  • MySQL Joins
  • MySQL INNER JOIN Keyword
  • MySQL LEFT JOIN Keyword
  • MySQL RIGHT JOIN Keyword
  • MySQL CROSS JOIN Keyword
  • MySQL Self Join
  • MySQL UNION Operator
  • MySQL GROUP BY Statement
  • MySQL HAVING Clause
  • MySQL EXISTS Operator
  • MySQL ANY And ALL Operators
  • MySQL INSERT INTO SELECT Statement
  • MySQL CASE Statement
  • MySQL NULL Functions
  • MySQL Comments
  • MySQL Operators
  • MySQL CREATE DATABASE Statement
  • MySQL DROP DATABASE Statement
  • MySQL CREATE TABLE Statement
  • MySQL DROP TABLE Statement
  • MySQL ALTER TABLE Statement
  • MySQL Constraints
  • MySQL NOT NULL Constraint
  • MySQL UNIQUE Constraint
  • MySQL PRIMARY KEY Constraint
  • MySQL FOREIGN KEY Constraint
  • MySQL CHECK Constraint
  • MySQL DEFAULT Constraint
  • MySQL CREATE INDEX Statement
  • MySQL AUTO INCREMENT Field
  • MySQL Working With Dates
  • MySQL Views
  • MySQL Data Types
  • MySQL Functions
  • Home
  • Courses
  • MySQL
  • MySQL DELETE Statement

MySQL DELETE Statement

Previous Next

The MySQL DELETE Statement

The DELETE statement is used to delete existing records in a table.
 

DELETE Syntax
DELETE FROM table_name WHERE condition;



Practice Excercise Practice now

Demo Database

Below is a selection from the "Customers" table in the Northwind sample database:

CustomerID CustomerName ContactName Address City PostalCode Country
1
 
Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany
2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constitución 2222 México D.F. 05021 Mexico
3 Antonio Moreno Taquería Antonio Moreno Mataderos 2312 México D.F. 05023 Mexico
4
 
Around the Horn Thomas Hardy 120 Hanover Sq. London WA1 1DP UK
5 Berglunds snabbköp Christina Berglund Berguvsvägen 8 Luleå S-958 22 Sweden



Practice Excercise Practice now

SQL DELETE Example

The following SQL statement deletes the customer "Alfreds Futterkiste" from the "Customers" table:
 

DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

The "Customers" table will now look like this:
CustomerID CustomerName ContactName Address City PostalCode Country
2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constitución 2222 México D.F. 05021 Mexico
3 Antonio Moreno Taquería Antonio Moreno Mataderos 2312 México D.F. 05023 Mexico
4
 
Around the Horn Thomas Hardy 120 Hanover Sq. London WA1 1DP UK
5 Berglunds snabbköp Christina Berglund Berguvsvägen 8 Luleå S-958 22 Sweden



Practice Excercise Practice now

Delete All Records

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:
 

DELETE FROM table_name;

The following SQL statement deletes all rows in the "Customers" table, without deleting the table:
 
DELETE FROM Customers;



Practice Excercise Practice now

Previous Next
COMPANY
  • About us
  • Careers
  • Contact Us
  • In Press
  • People
  • Companies List
Products
  • Features
  • Coding Assessments
  • Psychometric Assessment
  • Aptitude Assessments
  • Tech/Functional Assessments
  • Video Assessment
  • Fluency Assessment
  • Campus
 
  • Learning
  • Campus Recruitment
  • Lateral Recruitment
  • Enterprise
  • Education
  • K 12
  • Government
OTHERS
  • Blog
  • Terms of Services
  • Privacy Policy
  • Refund Policy
  • Mart Category
Partner
  • Partner Login
  • Partner Signup

Copyright © RVR Innovations LLP 2025 | All rights reserved - Mytat.co is the venture of RVR Innovations LLP