MySQL round down decimal number to nearest 0 or 5

Inspired by this post, I came out a way to round down a decimal number to nearest 0 or 5 in MySQL. For example: 1.27 -> 1.25, 3.23->3.20 MySQL code: SELECT TRUNCATE(value * 2, 1) / 2;


New syntax for new MySQL

Downloaded new version of MySQL database, version 4.1.12. Just like usual, many new features. When I execute my old PHP programs (version 4), there is an error occured that I can’t connect to my new MySQL database — old password is not usable. After searched the net, found few ways to overcome this as shown…

%d bloggers like this: