MySQL returns test examples that affect the number of rows

Found_rows (): Select

Row_count (): UPDATE Delete Insert

Note: You need to work with the appropriate operation, otherwise the value returned is only 1 and 1 (all 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 (returns the number of newly added records), [Note: If you use Insert into...values only return 1]

SELECT * from ' mytesttable '; select Found_rows (); --Output 3 (returns the number of rows selected)

Update ' mytesttable ' set ' Name ' = ' people '; select Row_count (); --Output 3 (returns the number of rows modified)

Delete from ' mytesttable '; select Row_count (); --Output 3 (returns the number of rows deleted)