jteixeira Posted November 14, 2006 Share Posted November 14, 2006 By wrong i make an update that update me all Table for 0.70, it is possible to put right that the begin? (Sorry my english) Link to comment Share on other sites More sharing options...
aspnetguy Posted November 14, 2006 Share Posted November 14, 2006 I really can't understand what you are asking. You updated a table and set everything to 0.70? There is no way to undo that if that is what you are asking.Inorder to narrow your update to only the desired records you need to use conditional statements (WHERE, AND, OR) Link to comment Share on other sites More sharing options...
jteixeira Posted November 14, 2006 Author Share Posted November 14, 2006 ok,thanks Link to comment Share on other sites More sharing options...
jteixeira Posted November 15, 2006 Author Share Posted November 15, 2006 It's a way to undo update tables Link to comment Share on other sites More sharing options...
justsomeguy Posted November 16, 2006 Share Posted November 16, 2006 There's not a way to undo a database transaction once it has been committed. The transaction will usually get rolled-back if it fails halfway through, but once it is finished and committed, you cannot undo it. The database management system does not usually save undo information, it would take up an extremely large amount of space to do so. Link to comment Share on other sites More sharing options...
jlhaslip Posted November 16, 2006 Share Posted November 16, 2006 Might have had a backup done.And there is a LIMIT feature in which restricts the number of rows affected, too. Might want to check that one out, too. Especially for deletes. Link to comment Share on other sites More sharing options...
jteixeira Posted November 16, 2006 Author Share Posted November 16, 2006 Store of System and back 2 two days behind. It works Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now