MySQL Forums
Forum List  »  Stored Procedures

Re: if condition
Posted by: Roland Bouman
Date: November 14, 2005 02:39AM

You can use ROW_COUNT() for INSERT, UPDATE and DELETE statements.
For select, you must write the SQL_CALC_FOUND_ROWS modifier in the SELECT list:

mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
-> WHERE id > 100 LIMIT 10;
mysql> SELECT FOUND_ROWS();
see: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html

and yeah, IF EXISTS (SELECT ..) works inside procedures.

Options: ReplyQuote


Subject
Views
Written By
Posted
10588
November 11, 2005 06:55AM
3710
November 11, 2005 06:23PM
2766
November 13, 2005 10:34PM
2584
November 13, 2005 10:37PM
Re: if condition
2387
November 14, 2005 02:39AM
2292
November 14, 2005 09:51AM
2173
November 15, 2005 03:14AM
2193
November 15, 2005 09:13AM
2154
November 15, 2005 12:50PM
2198
November 13, 2005 10:57PM
2002
November 13, 2005 11:52PM
1934
November 14, 2005 01:26AM
2048
November 14, 2005 06:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.