Can we rollback truncate in mysql?



Can we rollback truncate in mysql?..

Answer / Tarun Kumar Chaturvedi

No, TRUNCATE TABLE does not support the ROLLBACK command in MySQL. TRUNCATE TABLE removes all data from a table and resets the auto_increment values, but it cannot be undone with a regular ROLLBACK.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is the latest version of php and mysql?

1 Answers  


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

1 Answers  


table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1 Answers  


Explain advantages of MyISAM over InnoDB?

1 Answers  


Does facebook still use mysql?

1 Answers  


Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  


What is max connection in mysql?

1 Answers  


What is row level locking?

1 Answers  


In how many ways we can retrieve data in the result set of mysql using php?

1 Answers  


What is a transaction? Describe mysql transaction properties.

1 Answers  


What is information_schema in mysql?

1 Answers  


How to make a copy values from one column to another in mysql?

1 Answers  


Categories