Managing ODBC on Linux? What Happened to myodbc3i?

2012-04-17 Thread Robinson, Eric
We usually manage ODBC data sources on Linux using the myodbc3i utility that came with mysql-connector-odbc-3.51.30-1.rhel5.i386.rpm. When we upgraded to mysql-connector-odbc-5.1.10-1.rhel5.i386.rpm, it removed the myodbc3i utility. What GUI tool is now recommended to managing ODBC connections o

RE: forcing mysql to use batched key access (BKA) optimization for joins

2012-04-17 Thread Rick James
INDEX(o_orderdate, o_cust_key, o_orderkey) Would probably help a bunch. I assume you have indexes (PKs?) on c_custkey, l_order_key, n_nationkey. Please provide SHOW CREATE TABLE and SHOW STATUS TABLE. -Original Message- From: Hal?sz S?ndor [mailto:h...@tbbs.net] Sent: Tuesday, April 10,

Re: mysql friendly dates

2012-04-17 Thread william drescher
On 4/16/2012 3:04 PM, Haluk Karamete wrote: What's the right built in php date function formatting would be to take a simple date, that's in a format like 05/16/1960 and turn it into a mysql datetime datatype friendly format? I don't mind H M S to be as 00:00:00/ wrote my own: function US2ISODa

Shared memory protocol can be accessed in windows locally

2012-04-17 Thread SIVASUTHAN NADARAJAH
Dear all, I found the solution: 1. If you want to use the shared memory protocol locally on windows a. Stop the TCP/IP protocol by adding –skip-networking in my.ini file. b. Add the shared memory protocol by adding –shared-memory in my.ini file. c. Both should be adde