Archive for the ‘MySQL’ Category

MySQL Tutorial – Seeking records in a predefined order

November 9th, 2007 Comments off

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 where I had to show article listings on the home page based on the sequencing that I set through the admin control panel.

Read more…

Categories: MySQL Tags:

Difference between MySQL delete and truncate table

October 23rd, 2007 5 comments

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;


truncate table friends;

Read more…

Categories: MySQL Tags: