The TRUNCATE statement allows us to delete all the rows from a table. TRUNCATE is faster than a DELETE statement because it works by dropping the table and re-creating it empty. One thing to bear in mind is that TRUNCATE is not transaction safe.

Related Articles

• PHP: Rendering Web Pages Using the Composite View Design Pattern
• PHP Hex Color Chart
• Transferring PHP Files
• Server Side Scripting
• Ken Miller on Intelligent Design
• How to Moonwalk Tutorial
• How to get rid of acne without any products?
• [HD] T-ara – Apple is A
• How To Start Your Own Craft Business.
• Website Management on the go with the iPad

• Secure Encrypting and Decrypting for Your PHP Website
• PHP: Creating Single View Objects with the Composite View Design Pattern
• Facebook to kill IE6 support for Chat on IE9 beta day
• Hidden Images in Email to Confirm Receipt
• MySQL Column Size
• SQL Joins
• GD Library Basics
• Code Contracts in C# 4.0 – Part 1
• Photoshop Tutorial: Create a Colorful Explosion Retro Inspired Design
• The Roadmap to Becoming a Pro Twitter User