How to use MySQL 5.0 to delete data!

	MySQL Data Backup Tool BitDaddys Corp. $12.00 More Info Free Trial Buy Now!
Unique and Easy to use MySQL Database backups. Powerful Hourly Rotations. more ...

MySQL Tutorials Table Of Contents

Part 1: Start MySQL and Create Databases and Tables (Create)

Part 2: Add Data (Insert and Replace)

Part 3: Show Data (Select)

Part 4: Delete Data (Delete and Drop)

Part 5: Backup Data (Dump)

How to use C# and MySQL Connector/Net

How to use MySQL 5 Part 4: Delete Data
(greatly simplified)

This article and tutorial describes and demonstrates how you can:

[ click here ] Delete data from tables using the DELETE command
[ click here ] Delete tables and databases using the DROP command

What is the MySQL DELETE Command?

The MySQL DELETE command is how you remove information in database tables you create and use. It is the primary way of deleting rows of information from your mysql database.

DELETE SYNTAX

How do I remove data in MySQL 5 using the Delete Command?

Steps To Delete Data using the MySQL DELETE Command	Visual Demonstration
Open the MySQL Command Line and select your database Type 'DELETE' Type From and your table name 'From mytable' Type the where clause to describe which rows to delete 'where id='101';'

Syntax:

DELETE FROM ItemTable WHERE ItemName='Hamburger'

" For the single-table syntax, the DELETE statement deletes rows from tbl_name and returns the number of rows deleted. The WHERE clause, if given, specifies the conditions that identify which rows to delete. With no WHERE clause, all rows are deleted. ... "

more info...

[ return to top ]

What is the MySQL the Drop Command?

The MySQL DROP command is how you can delete a table or database. It is the a way of removing your mysql table or mysql database.