Tag: Differences between DROP and TRUNCATE

Differences between DROP a table and TRUNCATE a table?

January 10, 2010 | Filed Under PHP | Comments Off

DROP: This will delete the table structure and its data.

syntax-DROP TABLE table_name

TRUNCATE: This will delete the table  data but not its structure.
syntax-TRUNCATE TABLE table_name

Article written by admin

© PHPInterviewQuestion.com 2009 - 2012

eXTReMe Tracker