MySQL Delete Query

Delete Syntax

DELETE FROM 'table_name'

To execute MySQL query in PHP is easy, write the following code and replace CODE with your MySQL query:

<?php mysql_query("CODE"); ?>

One of the previous articles I showed you how to create a MySQL database, insert select and update rows. Now I show you how to delete rows from the students table.

Delete all rows

This will delete all rows from students table.

DELETE FROM 'students'

Result

After all rows deleted, students table will be empty.

idfirst_namelast_namegender
       

Delete only one row

This will delete only one row, where first_name is Ronald.

DELETE FROM 'students' WHERE 'first_name' = 'Ronald'

Result

idfirst_namelast_namegender
1 Jack Daniels male 
2 Lara Croft female
4 Mickey Mouse male

Delete more rows

Remember, if the value is string, it has to be put between  ' ' to work, for numbers ' ' do not needed.

DELETE FROM 'students' WHERE 'first_name' = 'Lara' OR 'id' = 3

Result

idfirst_namelast_namegender
1 Jack Daniels male 
4 Mickey Mouse male


Go Daddy


Related articles

Email Validation

Email Validation

08/02/2013

Learn how to validate email on client side with HTML5, Javascript and on server side with PHP.

Generate Thumbnail on the Fly with PHP

Generate Thumbnail on the Fly with PHP

04/02/2013

In a previous artice I already showed you how to generate square thumbnails with PHP. Now I show you how to keep the original ratio of the image and how to control the alignment of the square image.

Facebook Upload Photo to User′s Profile

Facebook Upload Photo to User′s Profile

31/01/2013

Learn how to upload a photo to Facebook user′s profile with PHP SDK via Graph API!


1 comment

Soinoultgigue2012-12-12 20:03

This actually answered my challenge, thank you!

Leave a comment

We welcome any comment from you! Please keep in mind that comments are moderated and rel='nofollow' is in use. So, please do not use a domain as your name or a spammy keyword, or your comment will be deleted.

Name: *

E-mail: *

Message: *

Click on the baby *


Find us on Facebook

Tags

Get online with the world's Best - GoDaddy.com!

Back to Top