Group By Problem

2011-02-08 Thread Adarsh Sharma
Dear all, I stuck around one more simple problem today. I have a table named *event_loc* having below data : ( It has many columns but I show you main columns that I needed ) _*Tables Data :-*_ *source_idevent_text* 1233 meet 1233

RE: Group By Problem

2011-02-08 Thread Peter He
You need to group by event_text, not obj_text: select source_id ,event_text,count(*) from event_loc group by source_id,event_text; Date: Tue, 8 Feb 2011 16:31:39 +0530 From: adarsh.sha...@orkash.com To: mysql@lists.mysql.com Subject: Group By Problem Dear all, I stuck around one

Replacing MS SQL with MySql

2011-02-08 Thread Y z
I have a windows app that wants to talk to either a) an access database, b) a MS Sql Express database, or c) a MS Sql 2008 database. Can anyone please point me in the direction of configuring My Sql to imitate any of the above? Thanks! -- MySQL

Re: Replacing MS SQL with MySql

2011-02-08 Thread Johan De Meersman
No way to do that directly; however, using the MySQL ODBC connector you can get at least a) and c) to play passthrough. Performance will likely suffer, though; especially Access' Jet Engine has a tendency to pull in full remote datasets instead of passing through the query. On Wed, Feb 9, 2011

Re: Replacing MS SQL with MySql

2011-02-08 Thread Reindl Harald
Am 09.02.2011 06:36, schrieb Y z: I have a windows app that wants to talk to either a) an access database, b) a MS Sql Express database, or c) a MS Sql 2008 database. Can anyone please point me in the direction of configuring My Sql to imitate any of the above? no way if the

Re: Replacing MS SQL with MySql

2011-02-08 Thread Johan De Meersman
On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald h.rei...@thelounge.netwrote: Am 09.02.2011 06:36, schrieb Y z: I have a windows app that wants to talk to either a) an access database, b) a MS Sql Express database, or c) a MS Sql 2008 database. Can anyone please point me in the direction

RE: Replacing MS SQL with MySql

2011-02-08 Thread David Brian Chait
To borrow your line of reasoning, translators can be rather slow and unreliable. Adding the extra overhead and complexity is certainly not worth the potential gains. -Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Tuesday,

Re: Replacing MS SQL with MySql

2011-02-08 Thread Johan De Meersman
On Wed, Feb 9, 2011 at 7:55 AM, David Brian Chait dch...@invenda.comwrote: To borrow your line of reasoning, translators can be rather slow and unreliable. Adding the extra overhead and complexity is certainly not worth the potential gains. I daresay that's up to the user to decide, no? OP