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 field10 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 field10.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
RE: what's wrong with EXPLAIN?
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 field10 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 field10.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
what's wrong with EXPLAIN?
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 field10 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 field10.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
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 field10 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 field10.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