Database

Explicit Order for 'ORDER BY' Clause in MySQL
You can explicit specify the order with which the 'ORDER BY' statement sort the data in MySQL. Lets say you have a priority field that has the values "Low" "High" or "Medium" - this is what you should do to sort the data from the highest to the lowest priority.
phpMiniAdmin
If you are working on the LAMP Platform, you would have encountered the MySQL Database administration tool 'phpMyAdmin'. Almost all web control panels provide phpMyAdmin for managing the database. Its a great software - it has a lot of features. But there is a price associated with having that much features - its bulky. It takes some time to load and use. And since it is on the web, that makes it even slower.
Naming Conventions in Database Design
When doing database design, one thing always plagued me - the lack of a common convention that can be to create the database design.

Database Clients

phpMyAdmin
There are many MySQL Clients(or database administration tools) out there - MySQL Front End, Tora, mysql etc. But in the web environment, one client rules - phpMyAdmin. phpMyAdmin is a PHP based(obviously) GUI administration tool for MySQL.
phpMiniAdmin
If you are working on the LAMP Platform, you would have encountered the MySQL Database administration tool 'phpMyAdmin'. Almost all web control panels provide phpMyAdmin for managing the database. Its a great software - it has a lot of features. But there is a price associated with having that much features - its bulky. It takes some time to load and use. And since it is on the web, that makes it even slower.
Subscribe to Feed