DELETE MySQL Tables

PHP Script

Java Script

Jquery Script

AJAX Script

JSP Script

Perl Script

Shell Script

ASP Script

Licensed Scripts

Premium Icons

HTML Tutorials	CSS Tutorials
Photoshop Tutorials	Flash Tutorials
JavaScript Tutorials	Jquery Tutorials
JSP Topics	Php Tutorials
MYSQL Tutorials	Regular Expression
Perl Tutorial	Domain & Dns
Unix Commands	C++
Vista Services	Linux Services
Web Building	Seo Tutorial
Powerpoint	VB.Net Tutorial
Rss Feed	GIMP

Clipart Pictures

Signs

Country Maps

Country Emblems

Background Images

Menu buttons

Logos

Menu Builder	Button Creator
Link Analyzer	DNS Lookup
Website Popularity	Color Chooser
Apache Ver Lookup	Page Rank Checker
Case Converter	Form Generator
Statistics	Epoch-GMT Converter
Hours Calculator	Htpasswd Generator
Favicon Generator	Backlink Checker
Image Crop Tool	Chart and Graph Tools
Multiple Drop Down Menu	Email Verification Tool
If Modified Since	Language Subtags
FBLike Count Calculator	SEO Text Browser

MySQL Tutorial

Home

Scripts

Tutorials

Images

Tools

Purchase

Snippets

Mysql Tutorial

Introduction

How to Install

Database

Datatypes

Tables

INSERT

SELECT

UPDATE

DELETE

Operators

Functions

Ask Your Doubts

Feedback

Delete MySQL Tables

Tutorials

Mysql

Topic

Delete MySQL tables data using Delete query.

Explanation

Delete Statement :

The delete statement is used to delete the values from a table.

The syntax is


DELETE FROM tbl_name
[WHERE where_condition];

The Delete statement deletes the rows from tbl_name and returns the number of rows deleted. The WHERE clause is used to specify the conditions that identify which rows to be deleted. If the DELETE query contains without WHERE clause, all rows will be deleted.


mysql> delete from student where name='michael';
Query OK, 1 row affected (0.00 sec)

This is an example of delete statement The above example will delete the record of the student Michael from the table.

We can also delete mysql tables all values as the following query.


mysql> delete from student;
Query OK, 8 rows affected (0.00 sec)

This simple delete query used to delete all data in a table.

A Note

MySQL is the most popular open source Relational database Management system (RDBMS). Being a open source anyone can use and change the software for their needs. Hope you enjoy this tutorial. We welcome your Valuable feedbacks or suggestions on this MySQL tutorial. This is a copyright content.