How to use MySQL 5.0 to delete data!

Main Menu

Home

.net Network Security

Flash

Fireworks

PHP

DB/C

Java

Email File Extensions

EML email file extension

MSG email file extension

TNEF email file extension

TXT email file extension

HTML email file extension

Java Script

OISV - Organization of Independant Software Vendors - Charter Member

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.