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 wrote: > 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 never specified

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, Fe

Re: Replacing MS SQL with MySql

2011-02-08 Thread Johan De Meersman
On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald wrote: > 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 configu

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
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 at

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 Gene

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 arou

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