This statement is used to delete all rows from the table. Its similar like DELETE statement BUT it does not have WHERE clause in it.
Syntax:
DELETE ALL DATA in table without deleting table structure, index, constraints.
TRUNCATE TABLE "tableName";
Parameters :
tableName : Name of the table which we wish to truncate.
Examples :
We will be using the same table which we have created in the CREATE TABLE and INSERT STATEMENT.
Using Select to see all the records before truncate query runs.
SELECT * FROM `employee`;
TRUNCATE TABLE `employee`;
Above query will delete all the rows in the specified table. Its faster than DELETE query.
Using Select to see all the records after delete query. We are using COUNT(*) function to know about numbers of rows in our table. And its 0 (zero), Which confirms deletion of all rows in the table.
When it comes to children, there’s one universal truth: the right toy can spark imagination, build skills, and make memories…
In today’s digital age, where screens and gadgets dominate our children’s lives, there’s something heartwarming about a well-loved plush toy…
In a world dominated by screens and fast-paced routines, it’s easy to forget the simple magic of a toy in…
In the heart of Delhi’s vibrant streets lies a world where imagination meets innovation — the magical universe of toys.…
When was the last time a toy truly amazed you—not just as a product, but as a thoughtful tool for…
In the digital age, the way we experience childhood has changed, but the essence remains the same—imagination, exploration, and joy.…
