Group By Problem
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 meet 1345ends 1345ends performs 13456 Minister 1233Argentina 1233meet 1345ends 1555is As described above there are more than 10 rows and I want my output as : _*Output Needed :-*_ *source_id event_text Count* 1233 meet 3 1233 Argentina 1 1345 ends3 performs 1 13456 Minister 1 I tried the below query : *select source_id ,event_text,count(*) from event_loc group by source_id,obj_text ;* But displays only unique record_id rows but I want as mentioned output. Failed to achieve the mentioned output. Thanks Regards Adarsh Sharma
RE: Group By Problem
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 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_id event_text* 1233 meet 1233 meet 1345 ends 1345 ends performs 13456 Minister 1233 Argentina 1233 meet 1345 ends 1555 is As described above there are more than 10 rows and I want my output as : _*Output Needed :-*_ *source_id event_text Count* 1233 meet 3 1233 Argentina 1 1345 ends 3 performs 1 13456 Minister 1 I tried the below query : *select source_id ,event_text,count(*) from event_loc group by source_id,obj_text ;* But displays only unique record_id rows but I want as mentioned output. Failed to achieve the mentioned output. Thanks Regards Adarsh Sharma
Replacing MS SQL with MySql
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Replacing MS SQL with 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 at 6:36 AM, Y z yan...@hotmail.com wrote: 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Replacing MS SQL with MySql
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 application has no abstraction-layer you can not easy switvh from one rdbms to another because in a closed source app you will even not can connect after connect there are hughe differences in many details so if a application does not support a specific rdbms you can not use it signature.asc Description: OpenPGP digital signature
Re: Replacing MS SQL with MySql
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 of configuring My Sql to imitate any of the above? no way if the application has no abstraction-layer you can not easy switvh from one rdbms to another because in a closed source app you will even not can connect after connect there are hughe differences in many details so if a application does not support a specific rdbms you can not use it Remember, TIMTOWTDIhttps://secure.wikimedia.org/wikipedia/en/wiki/TIMTOWTDI:-) If someone you want to talk to knows only one language, find an interpreter. MS Access apparently speaks the same language as his app; and using ODBC it can also talk MySQL. Link the tables in Access and let the app use them as if they were regular tables. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
RE: Replacing MS SQL with MySql
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, February 08, 2011 10:54 PM To: Reindl Harald Cc: Y z; mysql@lists.mysql.com Subject: Re: Replacing MS SQL with MySql 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 of configuring My Sql to imitate any of the above? no way if the application has no abstraction-layer you can not easy switvh from one rdbms to another because in a closed source app you will even not can connect after connect there are hughe differences in many details so if a application does not support a specific rdbms you can not use it Remember, TIMTOWTDIhttps://secure.wikimedia.org/wikipedia/en/wiki/TIMTOWTDI:-) If someone you want to talk to knows only one language, find an interpreter. MS Access apparently speaks the same language as his app; and using ODBC it can also talk MySQL. Link the tables in Access and let the app use them as if they were regular tables. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Replacing MS SQL with MySql
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 never specified why he needs the application to connect to a MySQL DB. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel