PHWinfo - Afficher un message

04/05/2006, 17h36

andrea azzini wrote:
> I ran the queries using the MySQL Query Browser software
> (http://www.mysql.com/products/tools/query-browser/)
> and the result of found_rows was 1.

MySQL Query Browser opens a new connection for each statement you
execute. The value returned by FOUND_ROWS() is relevant only during the
current connection. So there is no way to use this function in MySQL
Query Browser; you must use the command-line tool 'mysql'.

FWIW, the same issue happens when trying to use other session-dependent
features in MySQL Query Browser, such as LAST_INSERT_ID() and user
variables.

Regards,
Bill K.

04/05/2006, 17h36	#7
Bill Karwin Messages: n/a Hébergeur:	Re: found_rows() everytime returns 1 andrea azzini wrote: > I ran the queries using the MySQL Query Browser software > (http://www.mysql.com/products/tools/query-browser/) > and the result of found_rows was 1. MySQL Query Browser opens a new connection for each statement you execute. The value returned by FOUND_ROWS() is relevant only during the current connection. So there is no way to use this function in MySQL Query Browser; you must use the command-line tool 'mysql'. FWIW, the same issue happens when trying to use other session-dependent features in MySQL Query Browser, such as LAST_INSERT_ID() and user variables. Regards, Bill K.