I give an example to make clear what I mean. I had a table with about 100 records scanned from a book. I scanned another 70 and when I finished with INSERT/correcting/INSERT ecc cycle, my table had about 500 records. Of course I had in mind this, so one field was set to '1' so I could delete them all new and re-insert to 70 records for last time. If I could use EXPLAIN to examine the 70 records, I hadn't to do this.
Makis > -----Original Message----- > From: savaidis [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 11, 2002 11:25 AM > To: [EMAIL PROTECTED] > Subject: RE: what's wrong with EXPLAIN? > > > 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 > --------------------------------------------------------------------- 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