Re: MySQL 3.23.44 not using indexes
On Mon, Apr 22, 2002 at 10:26:22PM -0700, Steven Roussey wrote: Inside the page: Any index that doesn't span all AND levels in the WHERE clause is not used to optimise the query. In other words: To be able to use an index, a prefix of the index must be used in every AND group. [Note: optimize is spelled wrong in the manual.] It is spelt in English, not American. That is not wrong! -- John Birrell http://r1-magic.ws/ - 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: mysql.org
On Sat, Jul 21, 2001 at 01:13:15PM +0100, Mark Tiramani wrote: Since these issues are between two private companies, please take your discussions off this list. It is none of our business. By all means, tell us the result. This discussion most certainly is our business. No it's not. MySQL is owned by MySQL AB. The fact that you get to use their code under GPL has no bearing on their commercial discussions. All these posts to this list only serve to inflame the situation. -- John Birrell - [EMAIL PROTECTED]; [EMAIL PROTECTED] - 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: mysql.org
On Fri, Jul 20, 2001 at 12:29:52PM -0400, Britt Johnston wrote: MySQL AB and NuSphere had a meeting over the phone, we exchanged information and opinions and NuSphere will propose times for the next meeting. Since these issues are between two private companies, please take your discussions off this list. It is none of our business. By all means, tell us the result. -- John Birrell - [EMAIL PROTECTED]; [EMAIL PROTECTED] - 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: INSERT INTO ... SET ...
On Fri, Jul 13, 2001 at 02:56:05PM +0800, Rolf Hopkins wrote: In all the years I have worked/studied SQL, not once have I come across the INSERT INTO ... SET ... syntax. My questions are: 1. Is this a valid statement? 2. Is it ANSI standard? 3. Is this a MySQL feature / bug or do other DBs support this? 4. If it is valid, where is it documented? All the SQL books that I've ever come across, do not contain such a syntax. It's documented in MySQL: http://www.mysql.com/doc/I/N/INSERT.html. That page says it has been supported since 3.22.10. -- John Birrell - [EMAIL PROTECTED]; [EMAIL PROTECTED] - 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