Re: strange select/join/group by with rollup issue....

2012-02-08 Thread Arthur Fuller
I'm not sure your method isn't working, but try changing changing the to date part to '2012-02-08' and see what you get. HTH, Arthur

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

2012-02-08 Thread Johan De Meersman
- Original Message - From: Stan Iverson iversons...@gmail.com Yes, it's a binary file; however, MySQL Connector for ODBC only works in Windows and I'm using a Mac. If no other solutions, will try tomorrow on a friend's PC. If it's binary, you're gonna have no other choice but to

Re: Tuning mysql

2012-02-08 Thread Luis Motta Campos
On 7 Feb 2012, at 00:55, Grant wrote: I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should change any settings. I'm using mysql with a website on the same server so I have skip-networking, and I increased key_buffer and innodb_buffer_pool_size from 16M to 256M. Everything

Re: strange select/join/group by with rollup issue....

2012-02-08 Thread Andy Wallace
Thanks, it seems to be working now. I just discovered WITH ROLLUP. It made me very happy on this project... On 2/8/12 2:54 AM, Arthur Fuller wrote: I'm not sure your method isn't working, but try changing changing the to date part to '2012-02-08' and see what you get. HTH, Arthur --

C api mysql_store_result vs mysql_use_result

2012-02-08 Thread Alex Schaft
Hi, I'm currently using mysql_store_result to retrieve all records of a query. This poses a problem however if say a couple of thousand records get returned, and the user gets no feedback during the progress. I now want to change this to mysql_use_result. The only catch is that you don't