Home > Software engineering >  Only necessary for 'transaction commit?
Only necessary for 'transaction commit?

Time:12-13

Regular update operation, the database is automatically commit support, as long as I'm ordinary update there would be no need to perform a commit?
 mysql> Show variables like '% % the autocommit mode; 
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- +
Value | | Variable_name |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- +
| the autocommit | ON |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- +
1 row in the set (0.00 SEC)

Mysql>

  • Related