You are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands givenwhether it will update and alter the table or not?
Your update should be recorded in the database. It depends on
what type of crash. You should have hardware redundency, which if
one component fails, a backup will ensure your update. All you can
really do, is once the system is back up, check the table to see if
the update is there.