MySQL查询受影响的行数

-- select 查询
SELECT * FROM table1;
SELECT FOUND_ROWS();

-- update delete insert
DELETE FROM table1 WHERE id = 1;
SELECT ROW_COUNT();

 

posted @ 2020-11-10 11:15  jardeng  阅读(1048)  评论(0编辑  收藏  举报