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

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 DEBU

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 reques

Re: auto_increment field behavior

2013-03-13 Thread spameden
2013/3/13 Reindl Harald : > > > 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-use the s

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: Retrieve most recent of multiple rows

2013-03-13 Thread Johan De Meersman
- Original Message - > From: "Ananda Kumar" > 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. -- Unha

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 wrote: > - Original Message - > > From: "Norah Jones" > > Subject: Retrieve most recent of multiple rows > > > > 4 10Male3 1363091019 >

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 wrote: > I have a table which looks like this: > > answer_id q_id answer qscore_id answer_timestamp

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 Johan De Meersman
- Original Message - > From: "Norah Jones" > Subject: Retrieve most recent of multiple rows > > 4 10Male3 1363091019 > 5 11Male3 1363091020 > 6 12Male3 1363091020 > 7 11Male3