If you're new here, you may want to subscribe to my Newsletter. Thanks for visiting!

You can use this tutorial in various projects where the requirement is to sequence the records based on the order that has already been predefined.

Imagine having to write code where you are supposed to display articles on the basis of an order predefined by the administrator of the site. I had a similar challenge with one of my sites www.careercurry.com where I had to show article listings on the home page based on the sequencing that I set through the admin control panel.

Both remove records from the table, so what is the difference. Very simple, read along.

For this article, I will use a ‘friends’ table.

delete from friends;

and

truncate table friends;