MySQL rollback on the MyISAM engine

mysql myisam
Bharanikumar picture Bharanikumar · Aug 4, 2010 · Viewed 7.1k times · Source

By mistake I ran the update query. This update made my table all rows values as o.

Is it possible to rollback the table values?

Answer

three-cups picture three-cups · Mar 10, 2011

MyISAM does not support transactions. Therefore, every individual statement runs as if it is enclosed by a transaction. You cannot roll it back.

Related questions

How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine?

Read More
How to properly create composite primary keys - MYSQL

Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate primary keys as the ID. info is a table that contains information about both table_1 and table_2. table_1 (id, field) …

Read More
MyISAM versus InnoDB

I'm working on a projects which involves a lot of database writes, I'd say (70% inserts and 30% reads). This ratio would also include updates which I consider to be one read and one write. The reads can be dirty (e.g. …

Read More