What does a successful MySQL DELETE return? How to check if DELETE was successful?

by

Assuming you are using mysql_query:

For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.

If you are using PDO::exec, then the manual says this:

PDO::exec() returns the number of rows that were modified or deleted by the SQL statement you issued. If no rows were affected, PDO::exec() returns 0.

Don’t want to answer snipe, but since this was selected as the answer, I should note that mysql_query will return TRUE even if the query did not actually remove anything. You should use mysql_affected_rows to check for that.

More Related Contents:

  1. How to find missing attendance from the database table
  2. Php mysql tabs don’t output [closed]
  3. Update Mysql except when field not null
  4. How to change mysql to mysqli?
  5. php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
  6. How do I use password hashing with PDO to make my code more secure? [closed]
  7. MySQLi prepared statements error reporting [duplicate]
  8. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  9. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  10. How do I import a .sql file in mysql database using PHP?
  11. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  12. PHP Fatal error: Class ‘PDO’ not found
  13. Connect to a MySQL server over SSH in PHP
  14. How to store NULL values in datetime fields in MySQL?
  15. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  16. a better approach than storing mysql password in plain text in config file?
  17. Selecting a float in MySQL
  18. mysql query result in php variable
  19. Javascript function post and call php script
  20. while ($row = mysql_fetch_array($result)) – how many loops are being performed?
  21. Unknown database error in PHP but it exists in PHPMyAdmin
  22. How do detect that transaction has already been started?
  23. How to get primary key of table?
  24. Simple way to read single record from MySQL
  25. How to insert json array into mysql database
  26. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  27. PHP PDO how to run a multiple query request?
  28. Backup a mysql database and download as a file
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. PHP/MySQL Pagination

Leave a Comment