delete all from table

Question

what s faster   DELETE FROM table name    or  DELETE FROM table name where 1 1    why   does truncate table work in access

User · Accepted Answer

You can use the below query to remove all the rows from the table  also you should keep it in mind that it will reset the Identity too   TRUNCATE TABLE table name

User · Answer

There is a  mySQL bug report from 2004 that still seems to have some validity  It seems that in 4 x  this was fastest  DROP table name CREATE TABLE table name  TRUNCATE table name was DELETE FROM internally back then  providing no performance gain  This seems to have changed  but only in 5 0 3 and younger  From the bug report    11 Jan 2005 16 10  Marko M  kel   I ve now implemented fast TRUNCATE TABLE  which will hopefully be included in MySQL 5 0 3

User · Answer

You can also use truncate   truncate table table name

User · Answer

This is deletes the table table name   Replace it with the name of the table  which shall be deleted   DELETE FROM table name

User · Answer

This should be faster   DELETE   FROM table name    because RDBMS don t have to look where is what   You should be fine with truncate though   truncate table table name

[sql] delete all from table

Examples related to sql

Examples related to mysql

Examples related to ms-access

Examples related to optimization

Examples related to performance