Laravel 5: return number of affected rows MySQL

Question

how to return something similar to PHP function mysql_affected_rows() when use Laravel 5 DB class,

ex: DB::delete("DELETE FROM chat WHERE user_id = {$mid}");

how to return number of affected rows?

thanks,

Answer 1

For update() and delete() calls, the return value is the number of affected rows.

Click to copy

$affected = DB::delete("DELETE FROM chat WHERE id = {$mid}");