I am probably wrong, but my assumption was that EXPLAIN was used to help optimize SELECT statements, not INSERT/UPDATE statements. So if I am thinking correctly (this time :-), EXPALAIN is erroring for you because it only deals with SELECT statements.
Cary At 12:10 PM 3/9/02, savaidis wrote: >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 --------------------------------------------------------------------- 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
