Update and create timestamps with MySQL

A lot of relational tables need created and update timestamps columns. I prefer having them for all tables with no exception. However, most of applications I am working on are running MySQL. MySQL has minor limitation on timestamps. Unfortunately you can create only one time stamp column that has DEFAULT NOW() value. Read more to [...]

WampServer

WampServer is a Windows web development environment. It allows you to create web applications with Apache, PHP and the MySQL database. It also comes with PHPMyAdmin to easily manage your databases. WampServer installs automatically (installer), and its usage is very intuitive. You will be able to tune your server without even touching the setting files. [...]

MySQL Indexing Sequence

The indexing should be the same sequence in the SQL used. SELECT `image_no` AS count FROM `images` WHERE `section`=’b_cars’ AND `ad_no`=’300483′ ORDER BY `image_no` DESC LIMIT 1 KEY `section` (`section`,`ad_no`,`order_no`,`image_no`) WHERE ORDER BY/GROUP BY SELECT