Many articles have been written to describe the difference between the DELETE and TRUNCATE statements. Moreover, it is one of the most common questions during job interviews. Both statements remove the data from the table. However, there are differences too.
This article will focus on these differences and illustrate them with practical examples.
Read MoreMySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL table. When we run this command, it drops the existing table first and then creates a new table using the table definition. The query execution sequence of the TRUNCATE TABLE command is DROP TABLE and CREATE TABLE.
Read MoreThis document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd April 2015 and 23rd April 2015. The details are specific to an application, but the principles may be useful to others in need of doing similar operations in production.
Read More