Name

TRUNCATE

Syntax

TRUNCATE TABLE table

Description

Drops and recreates the specified table.

Example

# Truncate the emp_data table
TRUNCATE TABLE emp_data;

Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial