MySQL database returns the actual operation flow that affects the number of rows

The following articles mainly describe the actual operation process of MySQL database return that affects the number of rows, we mainly introduce the specific operation steps of the application code when the MySQL database returns the affected number of rows. The following describes the main content of the article. Found_rows (): selectrow_count (): updatedeleteinsert note:

The following articles mainly describe the actual operation process of MySQL database return that affects the number of rows, we mainly introduce the specific operation steps of the application code when the MySQL database returns the affected number of rows. The following describes the main content of the article. Found_rows (): select row_count (): updatedeleteinsert note:

The following articles mainly describe the actual operation process of MySQL database return that affects the number of rows, we mainly introduce the specific operation steps of the application code when the MySQL database returns the affected number of rows. The following describes the main content of the article.

Found_rows (): select
Row_count (): update delete insert

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', 'Role 1'
Union all select '2', 'Role 2' union all select '3', 'Role 3'; 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 selected number of rows)

Update 'mytesttable' set 'name' = 'people'; select row_count ();

Output 3 (the number of modified rows is returned)

Delete from 'mytesttable'; select row_count ();

Output 3 (the number of rows to be deleted). The above content introduces the code that affects the number of rows returned by the MySQL database. I hope you will get some benefits.

　　

The above content is the description of the Code that affects the number of rows returned by the MySQL database. I hope it will help you in this regard.