I found - once again- strange behaviour on some MySQL functions, i.e. with EXPLAIN command. I give one very simple query : explain update mytable set field1 = round(field1,2) where field1>0 and it shows me an error! But when I execute it without 'explain', it updates the fields correctly. Why? (field1 is a real of cource and I tried "where field1>0.0" too with the same error) If I'm not shure 'explain' is working correctly, then how I will trust to use it? To show me errors where they doesn't exist?
Makis --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
