I'd like to know your opinion on monetary calculations. For accurate representation of monetary (euro) values I use DECIMAL fields (12,5).
Now: how to do safe calculations? Are these commands safe? 1) SELECT SUM(price) FROM ... 2) SELECT SUM(price * 1.2) FROM ... 3) SELECT SUM(price) * 1.2 FROM ... Do you think I should do all these things in PHP? Bye -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]