Re: Retrieve most recent of multiple rows

2013-03-13 Thread Johan De Meersman
- Original Message - From: Norah Jones nh.jone...@gmail.com Subject: Retrieve most recent of multiple rows 4 10Male3 1363091019 5 11Male3 1363091020 6 12Male3 1363091020 7 11

Re: Retrieve most recent of multiple rows

2013-03-13 Thread Ananda Kumar
this is the data i tested on AIDQID ANS SCRID ATIMESTAMP -- -- -- -- --- 1 10 male3 13-MAR-13 02.03.20.00 PM 2 10

Re: Retrieve most recent of multiple rows

2013-03-13 Thread Ananda Kumar
select * from tab where anwer_timestamp in (select max(anwer_timestamp) from tab where q_id in (select distinct q_id from tab) group by q_id); On Wed, Mar 13, 2013 at 6:48 PM, Norah Jones nh.jone...@gmail.com wrote: I have a table which looks like this: answer_id q_id answer qscore_id

Re: Retrieve most recent of multiple rows

2013-03-13 Thread Ananda Kumar
can you please share the sql that you executed to fetch the above data On Wed, Mar 13, 2013 at 7:19 PM, Johan De Meersman vegiv...@tuxera.bewrote: - Original Message - From: Norah Jones nh.jone...@gmail.com Subject: Retrieve most recent of multiple rows 4 10

Re: Retrieve most recent of multiple rows

2013-03-13 Thread Johan De Meersman
- Original Message - From: Ananda Kumar anan...@gmail.com Subject: Re: Retrieve most recent of multiple rows select qid,max(atimestamp) from kkk where qid in (select distinct qid from kkk) group by qid; What use is that where statement? It just says to use all the rows in the table.

Re: Blob implementation question

2013-03-13 Thread Adam Ilardi
Engine: MyISAM? InnoDB? other? InnoDB Let's see the SELECT. select bytes from table_name where id = %d If InnoDB, let's see the transaction, if it is part of such. It's a single query If InnoDB, which (COMPACT, etc) are you using. Not sure You

Re: auto_increment field behavior

2013-03-13 Thread spameden
2013/3/13 Reindl Harald h.rei...@thelounge.net: Am 12.03.2013 22:34, schrieb spameden: NOTE: AUTO_INCREMENT is 32768 instead of 17923 ! So next inserted row would have pc_id=32768. Please suggest if it's normal behavior or not what do you expect if a PRIMARY KEY record get's removed?

RE: Blob implementation question

2013-03-13 Thread Rick James
A lot of details are missing... Engine: MyISAM? InnoDB? other? Let's see the SELECT. If InnoDB, let's see the transaction, if it is part of such. If InnoDB, which (COMPACT, etc) are you using. You are asking about a single row with the 500MB, correct? In general, each

Re: Multi-Master Replication Manager - monitor works but mmm_control show executes very long and sometimes returns no output.

2013-03-13 Thread Rafał Radecki
I have used debug on monitor and agent: - on agent I see: /etc/init.d/mysql-mmm-agent start Starting MMM Agent Daemon: 2013/03/13 16:19:52 DEBUG Created pid file '/var/run/mysql-mmm/mmm_agentd.pid' with pid 13640 2013/03/13 16:19:52 DEBUG Listener: Waiting for connection... 2013/03/13 16:19:53

RE: How to return resultset from MySQL Stored Procedure using prepared statement?

2013-03-13 Thread Rick James
What language are you using? In Perl, there is $sth-more_results; -Original Message- From: Girish Talluru [mailto:girish.dev1...@gmail.com] Sent: Wednesday, March 13, 2013 5:24 AM To: mysql@lists.mysql.com Subject: How to return resultset from MySQL Stored Procedure using