hi all,
is there a way to perform a "controlled" rollback to (i dont want to use this word but i HAVE TO ) .. UNDO a mysql query? please refer to this link coz there is a class (mysql utility) that apparently can be used to "Perform controlled rollback to undo the last executed SQL query whenever POSSIBLE"... this is the site: - so can i know that it IS POSSIBLE to resotre my table?
http://www.phpclasses.org/browse/package/1697.html
the truth is i have committed a big sin! i updated records in a db without the WHERE.. meaning it updated ALL records.. and now i need to restore the db! pleeeeeeeeeze help!
this is what i did:
update members set Name='$name',Mobile='$mobile',Gender='$gender' ;"; - YES without saying WHERE.... si it ended up updating al records..
please help in this.. i am using mysql 3.23
faz
