Truncate with condition

sql mysql truncate
Sharpeye500 picture Sharpeye500 · Sep 14, 2010 · Viewed 127.8k times · Source

truncate ->this resets the entire table, is there a way via truncate to reset particular records/check conditions.

For ex: i want to reset all the data and keep last 30 days inside the table.

Thanks.

Answer

ceejayoz picture ceejayoz · Sep 14, 2010

No, TRUNCATE is all or nothing. You can do a DELETE FROM <table> WHERE <conditions> but this loses the speed advantages of TRUNCATE.

Related questions

List of tables to safely truncate in Magento?

Is there a list of tables that can be safely truncated in Magento? By safely, I mean to preserve products. I've got a few but want to know if there are more: core_url_rewrite # Only safe if no custom …

Read More
Why 'delete from table' takes a long time when 'truncate table' takes 0 time?

(I've tried this in MySql) I believe they're semantically equivalent. Why not identify this trivial case and speed it up?

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More