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.
