Re: "union" operator problems in MySQL v3.23?

2008-01-11 Thread Glenn Gillis
Jim Winstead wrote, On 1/11/2008 12:54 PM: On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote: Notwithstanding end-of-life status, is there an issue in MySQL v3.23 r.e. the "union" operator? My installation returns a syntax error on any query containing the union operator, even with

Re: "union" operator problems in MySQL v3.23?

2008-01-11 Thread Jim Winstead
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote: > Notwithstanding end-of-life status, is there an issue in MySQL v3.23 > r.e. the "union" operator? > > My installation returns a syntax error on any query containing the union > operator, even with the sample queries provided in the

"union" operator problems in MySQL v3.23?

2008-01-11 Thread Glenn Gillis
Notwithstanding end-of-life status, is there an issue in MySQL v3.23 r.e. the "union" operator? My installation returns a syntax error on any query containing the union operator, even with the sample queries provided in the documentation: mysql> SELECT REPEAT('a',1) UNION SELECT REPEAT('b',

RE: Download MySQL 4.0.30

2008-01-11 Thread iagosineiro
Hi, Joerg. Thanks for the response. In ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-4.0/ and other similars that I find looking for "mysql/Downloads/MySQL-4.0" in google there is only MySQL 4.0.26 and 4.0.27. >both the 4.0 and 4.1 MySQL release families have reached their end of >a

Mysql Help / Error Thx

2008-01-11 Thread Matthias L.
Dear Users I searched google, find alot of tips, but none of the them was successfully. After a db move with ibdata files, which cannot be dumped (cause of a table failure) we made a hardcopy of the files and moved it onto the new server. Eg. we copy ibdatafiles, the original my.cnf to the new

Re: Single Column Indexes Vs. Multi Column

2008-01-11 Thread Sebastian Mendel
Perrin Harkins schrieb: On Jan 11, 2008 7:22 AM, Sebastian Mendel <[EMAIL PROTECTED]> wrote: i can only find one source in the manual, where MySQL is using more than on index: http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html Uh, how many sources do you need? 1? It us

Re: Single Column Indexes Vs. Multi Column

2008-01-11 Thread Perrin Harkins
On Jan 11, 2008 7:22 AM, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > i can only find one source in the manual, where MySQL is using more than on > index: > > http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html Uh, how many sources do you need? It uses multiple indexes, just lik

Re: Single Column Indexes Vs. Multi Column

2008-01-11 Thread Sebastian Mendel
C.R.Vegelin schrieb: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? IMHO, but i heard elselike too, but cannot find any proof in the manual ... -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: Single Column Indexes Vs. Multi Column

2008-01-11 Thread Sebastian Mendel
Sebastian Mendel schrieb: Anup Shukla schrieb: C.R.Vegelin wrote: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? AFAIK, MySQL (atleast from version 5.0 onwards) is capable of using multiple indexes. i have heard of somethin

Re: Single Column Indexes Vs. Multi Column

2008-01-11 Thread Sebastian Mendel
Anup Shukla schrieb: C.R.Vegelin wrote: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? AFAIK, MySQL (atleast from version 5.0 onwards) is capable of using multiple indexes. i have heard of something similar too, but cannot f

Re: Download MySQL 4.0.30

2008-01-11 Thread Joerg Bruehe
Iago, all, Joerg Bruehe wrote: [EMAIL PROTECTED] wrote: [[...]] couldn't find in HYPERLINK "http://www.mysql.com"www.mysql.com or in the web the file mysql-standard-4.0.27-pc-linux-gnu-i686.tar.gz. Also the link HYPERLINK "http://downloads.mysql.com/archives.php"http://downloads.mysql.com/arc

Re: Single Column Indexes Vs. Multi Column

2008-01-11 Thread Anup Shukla
C.R.Vegelin wrote: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? AFAIK, MySQL (atleast from version 5.0 onwards) is capable of using multiple indexes. -- Regards, Anup Shukla -- MySQL General Mailing List For list archives:

Re: Download MySQL 4.0.30

2008-01-11 Thread Joerg Bruehe
Iago, all, [EMAIL PROTECTED] wrote: Hi. I has a Linux server with MySQL 4.0.27 and I want to upgrade to 4.0.30 but I both the 4.0 and 4.1 MySQL release families have reached their end of active development and are in "extended lifecycle" only. This means there is neither development not co

Re: Single Column Indexes Vs. Multi Column

2008-01-11 Thread C.R.Vegelin
Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? Regards, Cor - Original Message - From: "Sebastian Mendel" <[EMAIL PROTECTED]> To: "Michael Stearne" <[EMAIL PROTECTED]>; "MySQL List" Sent: Thursday, January 10, 2008 6: