MySQL：未找到行时返回DELETE查询

Question

When I try to DELETE something from MySQL database that does not exist the query returns TRUE.

I want to know when nothing is deleted. Do I need to have a previous query to find if there are rows to be deleted?

Is there a more simple way to do this? I mean, using a single query?

I'm using php to connect to the database with the mysqli_query() function.

Answer 1

Use mysqli_affected_rows function to find the number of records affected by the previous query.