starting multiple mysql instances automatically

2005-02-22 Thread Tom Butterworth
Hi OS and MySQL version: Darwin, Mac OS X 10.2.8, MySQL 4.0.21-standard I have 2 mysql servers happily running on the same box. The default server being on 3306 and socket mysql.sock. With a second server running on 3307 with socket mysql1.sock. I can start and stop these fine from the command

rounding problem

2004-10-25 Thread Tom Butterworth
Hi I seem to be having problems returning the expected results when using the mysql ROUND() function. Rounding 3.565 to 2 decimal places i would expect to return 3.57 however using SELECT ROUND(3.565, 2); it returns 3.56. While using SELECT ROUND(3.575, 2); works as expected returning 3.58. I