mysql - Reverse an sql statement? -

mysql - Reverse an sql statement? -

i have sql file alot of create, alterings , modifies database. if need out @ point (up day maybe) after executing sql script, there easy way that? example, there tool read sql script , produce 'rollback' script it?

i using sqlyog aswell, in case there happens such features built-in (i havn't found any)

no, sorry, there many statements cannot reversed looking @ sql command.

drop table (what in table dropped?) update mytable set timestamp = now() (what timestamp before?) insert mytable (id) values (null) (assuming id auto-increment, row created?)

many others...

if want recover database before day's worth of changes, take backup before begin changing it.

you can point-in-time recovery using binary logs, restore database moment since lastly backup.

mysql sql sqlyog