MySQL Tutorials - Herong's Tutorial Examples - v4.46, by 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) 1999 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.
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
►Using DML to Insert, Update and Delete Records
INSERT INTO - Statement to Insert Records to Tables
UPDATE - Statement to Update Records in Tables
►DELETE FROM - Statement to Delete Records from Tables
Using SELECT to Query Database
Window Functions for Statistical Analysis
Use Index for Better Performance
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
System, User-Defined and Stored Procedure Variables
Storage Engines in MySQL Server
InnoDB Storage Engine - Primary and Secondary Indexes
Performance Tuning and Optimization
Installing MySQL Server on Linux