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 ...

Use sp_MSforeachtable to apply a T-SQL command to every table of selected Database in SQL Server --When we require executing same T-SQL command for all the tables, we can use this stored procedure.

Find and fix vulnerabilities Actions ...

TRUNCATE comes under DDL(Data Definition Language). TRUNCATE removes only rows from the table but the structure of the table remains same. Data can not be roll backed if we use "TRUNCATE" command to ...