Deleting from a mysql database
Deleting from a mysql database is even easier than inserting.
Category: Coding
Views: 1145

Deleting from a mysql database Deleting from a mysql database

Deleting from a mysql database is even easier than inserting.

Code:
mysql_query();
Our mysql query function

Code:
mysql_query("delete from table_name ");
This will delete all the rows from the table.

To avoid this you can tell it to delete it if it has a certain value.

Code:
mysql_query("delete form table_name where id='1' ");
This will delete the row where the id has the value 1.
Or you can tell it to delete everything that is not equal to a value.

Code:
mysql_query("delete from table_name where id!='1' ");
This deletes everything where the id is not equal to one.

If you would like more help with this tutorial please register and visit the forum.

About Michael

Michael Dunlop Michael Dunlop personal statement

“But I am already older than 21”, I hear you cry. Don’t worry, despite the name, the information and advice is more geared towards retiring prior to having a fake hip installed.

Website Sponsors
Recommended Websites
They Buy, Build, Upgrade and Sell Websites.
 
Advertise Here
Feature Interviews
Graham went from $100 one day to ... Read more
Paul Bourque started affiliate marketing less than ... Read more
Interview with Yaro Starak of Entrepreneurs-Journey.com is ... Read more
Recommended Resources
 
 
 
 
 
Get Retire at 21's FREE Secrets
Find out how I'm going to Retire VERY Early Subscribe for my Free Secrets Privacy Guaranteed. 100% Spam free.