nt | |
| |650851 |where used; Using
temporary; Using filesort
Could by simply changing the date in this query alter the keys that are used
and the number of rows it is required to sort through? It doesn't make
sense.
Thanks,
Hi,
I was wondering if MySQL allows the ability to perform a SQL Prepare on sql
statements prior to performing an execute.
I'm using ADO on Windows and with a CommandPtr object, you can set a
property called "Prepared", that will attempt to prepare sql statements and
will keep them prepared for
Hi,
I'm using ADO with the MyODBC driver.
I have a table that I'm querying that has 'datetime' columns. If these
columns are null or 0 - "-00-00 00:00:00", I have problems reading from
the ADO recordset.
I have other columns - char, varchar, integer etc that are null and don't
have this pro
