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