delete all record from table in mysql

Question

I am trying to delete all records from a table  My query is   delete from tableName    But it reports the following error      Error Code  1175  You are using safe update mode and you tried to   update a table without a WHERE that uses a KEY column To disable safe   mode  toggle the option in Preferences -  SQL Editor -  Query Editor   and reconnect     How do I resolve this

User · Answer

truncate tableName  That is what you are looking for    Truncate will delete all records in the table  emptying it

User · Answer

It   s because you tried to update a table without a WHERE that uses a KEY column   The quick fix is to add SET SQL SAFE UPDATES 0  before your query     SET SQL SAFE UPDATES 0     Or   close the safe update mode  Edit -  Preferences -  SQL Editor -  SQL Editor remove Forbid UPDATE and DELETE statements without a WHERE clause  safe updates     BTW you can use  TRUNCATE TABLE tablename  to delete all the records

[mysql] delete all record from table in mysql

Examples related to mysql