Thanks. But I think, it would be more usefull to INSERT/UPDATE as they change the talbe's contents.
Makis > -----Original Message----- > From: Cary [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 11, 2002 12:16 AM > To: [EMAIL PROTECTED] > Subject: Re: what's wrong with EXPLAIN? > > > 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 > --------------------------------------------------------------------- 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