[Solved] Delete From ,Statement Query Failure [closed]

Question

If you want to remove only some entries, you should not use DELETE but UPDATE to your null value (if nullable). For instance

UPDATE login 
SET username = null, last_seen = null
WHERE username = ?;

DELETE is intended for deleting rows.

Accepted Answer

If you want to remove only some entries, you should not use DELETE but UPDATE to your null value (if nullable). For instance

UPDATE login 
SET username = null, last_seen = null
WHERE username = ?;

DELETE is intended for deleting rows.