title: MySQL Stop a user from deleting an entire table
body: <p>I have a table that contains millions of records in MySQL.
  Is there a way to prevent users from <strong>accidentally executing</strong> &quot;delete from table1;&quot; and only allow them to delete records by executing this query &quot;delete from table1 where id=10;&quot;</p>
  <p>Currently the user privilege is &quot;GRANT SELECT, INSERT, DELETE ON <code>db1</code>.<code>table1</code> TO 'user'@'localhost'&quot;.</p>
  <p>Thanks.</p>