TRUNCATE Command
TRUNCATE Command
Description:
The TRUNCATE command is used to delete all records from a table, but the table structure remains.
Syntax:
TRUNCATE TABLE table_name;Example:
TRUNCATE TABLE student;
SELECT Command
SELECT Command Description: The SELECT command is used to retrieve data from a table. Syntax: SELECT * FROM table_name; Example: SELECT * FROM student;
Comments
Post a Comment