MySQL transaction rollback demonstration detailed explanation

MySQL transaction rollback demonstration detailed explanation

1. First look at the data in the student table

2. Enter start transaction to open the transaction

3. Update first Row the data, and then check the results and find that the update was successful.

4. Pay attention, the rollback starts here. Enter rollback. Then look at the data in the first row, and you can find that it has changed back with the new data.

5. Finally, when we look at the entire table, we can see that it is still the same as before.

The above is the detailed content of MySQL transaction rollback demonstration detailed explanation. For more information, please follow other related articles on the PHP Chinese website!