TRUNCATE TABLE

Updated on 2022-11-18 GMT+08:00

Function

This command is used to clear all data in a specific table.

Syntax

TRUNCATE TABLE tableIdentifier

Parameter Description

Table 1 Parameters

Parameter

Description

tableIdentifier

Table name.

Examples

truncate table h0_1;

System Response

Data in the table is cleared. You can run the QUERY statement to check whether data in the table has been deleted.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback