-- MAGIC - CSV table do not support Delete Operation, and we may have to use truncate in that case. -- MAGIC - in general truncate will delete complete table data, however we can specify constraint ...
This article explains the use and difference of DELETE, TRUNCATE and DROP statements of MySQL. 1. DELETE : DELETE command is used to delete all or specific records from MySQL table. The records delete ...
2..TRUNCATE command TRUNCATE command removes all the records from a table. But this command will not destroy the table's structure. When we use TRUNCATE command on a table its (auto increment) primary ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback