(The concept of business A business refers to a logical group of operations. The various units that make up this group of operations are either fully successful or fully unsuccessful. For example, A-B transfer corresponds to the following two SQL statements: updateaccountsetmoney=money-100where name='a'; updateaccountsetmoney=money 100wherename=‘b’; The default business of the database is automatically submitted, that is, it will perform one SQL statement. If you want to perform multiple SQL statements in one business, you need to use the following statements. Database open business command starttransaction open business Rollback rollback business Commit submit business)
收藏
