MySQL Tutorials - Herong's Tutorial Examples - Version 4.20, by Dr. Herong Yang
DELETE FROM - Statement to Delete Records from Tables
A tutorial example is provided on how to use DELETE FROM statements to delete records from tables.
A delete statement allows you to delete existing rows from an existing table. The syntax of a delete statement is:
DELETE FROM tbl_name [WHERE clause]
If executed, all rows that satisfy the condition in the where clause will be deleted. If no "where clause" specified, all rows will be deleted.
Here is an example SQL code, DeleteRows.sql, showing you how to delete rows from an existing table:
-- DeleteRows.sql -- Copyright (c) 2015, HerongYang.com, All Rights Reserved. -- DROP TABLE IF EXISTS User; CREATE TABLE User (Login VARCHAR(8), Password CHAR(8)); INSERT INTO User VALUES ('herong','8IS3KOX'); INSERT INTO User (Login) VALUES ('mike'); DELETE FROM User WHERE Login = 'herong'; SELECT 'User table:' AS '---'; SELECT * FROM User;
If you run the code, you will get:
--- User table: Login Password mike NULL
The output looks alright to me.
Last update: 2015.
Table of Contents