RE: ODBC

2001-03-09 Thread AzzKicar
I recently got MyODBC to run on Win2k and it works fine. -Original Message- From: Gerald Jensen [mailto:[EMAIL PROTECTED]] Sent: March 9, 2001 6:53 AM To: Dave Loisel; MySql Subject: Re: ODBC Dave: Not sure I follow the question ... we have 50+ systems (WinNT Server or WinNT Workstatio

RE: indexes on TEMPORARY HEAP tables ignored in ORDER BY / GROUP BY

2001-03-09 Thread AzzKicar
For some strange reason, all HEAP table indexes only process WHERE clauses with = and <=> operators ONLY. There's nothing you can do about it. I'm pretty sure of that because I remember the MySQL mentions something like this about HEAP tables. -Original Message- From: Jeff S Wheeler [mail

RE: select within select

2001-03-09 Thread AzzKicar
This question is where the mySQL manual would save you tons of time. The procedure you are referring to is called a sub-select. Unfortunately, for some strange reason, MySQL does not support sub-selects at this time. However, I know from the development team that sub-select is a major TO-DO for t