MySQL SQL gets the last bar inserted id,update affects the number of rows

1. Get the last bar to insert data

LAST_INSERT_ID ();

2. Gets the number of update impact rows.

Row_count ();

mysql> UPDATE T    , SET address = ' beijing111 '    , WHERE id = 1    , and NAME = ' Yubowei '; Query OK, 1 row affected (0.30 sec) Rows matched:1  changed:1  warnings:0mysql> mysql>select
       
         Row_count (); +-------------+| Row_count () |+-------------+| 1 |+-------------+1 row in Set (0.00
         sec) mysql> 
           

MySQL SQL gets the last bar inserted id,update affects the number of rows