[MySQL]-Number of affected rows returned

(Test on MySQL 5.1.36)

Found_rows (): select
Row_count ():InsertUpdate Delete

 

Note: It must be used together with the corresponding operation. Otherwise, the returned values are only 1 and-1 (both incorrect values)

Example:

Drop Database If Exists 'Mytest ';
Create Database 'Mytest ';
Use 'Mytest ';

Drop Table If Exists'Mytesttable ';
Create Table'Mytesttable' ('id'Int, 'Name'Varchar(10));

    Insert    Into  'Mytesttable' ('id', 'name ')
  Select     '  1  '  ,  '  Role1  '     Union     All  
  Select    '  2  '  ,  '  Role2  '     Union     All  
  Select     '  3  '  , '  Role3  '  ;
  Select  Row_count ();  --  Output 3 (the number of newly added records is returned). [Note: If insert into... values is used, only 1 is returned.]  
    

  select     *     from   'mytesttable ';   
   select   found_rows ();   --   output 3 (return the number of selected rows)  

    
   
   Update   'mytesttable'   set   'name'  =  '  People   ' ; 
   select   row_count ();   --   output 3 (the number of modified rows is returned)  

Delete From'Mytesttable ';
SelectRow_count ();--Output 3 (return the number of deleted rows)