January 2011

MySQL Predefined Ordering

SELECT id FROM table WHERE id in (7,2,5,9,8) ORDER BY FIND_IN_SET(id,"8,2,5,9,7");

My Current Development setup

My current development environment and tools are as follows:

  • Windows Vista
  • Virtual Box
  • Ubuntu Server 10
  • LAMP Setup
  • PHPStorm IDE
  • Putty
  • ColorCop

Grant All statement for MySQL

GRANT ALL PRIVILEGES ON db_base.* TO db_user @'localhost' IDENTIFIED BY 'db_passwd';