Development/DataBase

[MySQL] row count 반환 - select, insert, delete, update

키르히아이스 2016. 9. 21. 20:40

select 일 경우 row count 는 

select found_rows();

http://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_found-rows


insert, delete, update 일 경우 row count 는

select row_count();

http://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_row-count