Differences between DROP and TRUNCATE a table?

January 15, 2010 | Filed Under MySQL | Comments Off

DROP TABLE table_name – This will delete the table and its data.

TRUNCATEĀ  TABLE table_name – This will delete the data of theĀ  trial offer table, but not the table definition.

Comments

Comments are closed.

© PHPInterviewQuestion.com 2009 - 2012

eXTReMe Tracker