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 |
What is the latest version of php and mysql?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
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
Explain advantages of MyISAM over InnoDB?
Does facebook still use mysql?
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
What is max connection in mysql?
What is row level locking?
In how many ways we can retrieve data in the result set of mysql using php?
What is a transaction? Describe mysql transaction properties.
What is information_schema in mysql?
How to make a copy values from one column to another in mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)