Detailed information about changing the default

Using retention points, simple ROLLBACK and COMMIT statements can write or undo the entire transaction. However, this is only possible for simple transactions; more complex transactions may require partial commit or rollback. For example, the process of adding an order described earlier is a transaction. If an error occurs, just go back to before adding the orders row; there is no need to fall back to the customers table (if it exists). To support rolling back part of a transaction, it must be possible to place placeholders at appropriate locations within the transaction block. This way, if you need to roll back, you can fall back to a placeholder. These placeholders are called retention points. To create a placeholder, use the SAVEPOINT statement as follows: Enter: savepoint delete; Each savepoint is given a unique name that identifies it so that when it rolls back, MySQL knows where to roll back. In order to rollback to the retention points given in this example, you can proceed as follows: Enter: rollback to deletel; the more retention points, the better. You can set as many retention points as you want in the MySQL code, the more

1. MySQL transaction-detailed explanation of using retention points and changing the default commit behavior

##Introduction: Using retention points Simple ROLLBACK and COMMIT statements can write or undo entire transactions. However, this is only possible for simple transactions; more complex transactions may require partial commit or rollback. For example, the process of adding an order described earlier is a transaction. If an error occurs, just go back to before adding the orders row; there is no need to fall back to the customers table (if it exists). To support rolling back part of a transaction, placeholders must be placed at appropriate locations in the transaction block. This way, if you need to roll back, you can fall back to a placeholder.

2. How to change the default upload file button style using pure html and css

##Introduction: If you have ever tried it, you will know that implementing a unified upload file button using pure CSS styles and HTML can be troublesome. Take a look at the screenshots from different browsers below. Obviously, they look very different

3.

How to change the default upload file button style using pure HTML and CSS_html/css_WEB-ITnose

Introduction: How to change the default upload file button style using pure HTML and CSS

4.

Laravel 5.1 Change the default login jump Path

Introduction: Laravel 5.1 Change the default login jump path

5.

Change the Oracle database connection portIntroduction: The default database listening and connection port of the Oracle database is 1521, but sometimes the default port needs to be changed in the project. This is often required by customers and is based on security considerations. Take Ora

6 .

CAPI function description (G-N)

Introduction: 25.2.3.26. mysql_get_character_set_info() void mysql_get_character_set_info(MYSQL *mysql, MY_CHARSET_INFO *cs) Description This function provides Information about the default client character set. The default character set can be changed using the mysql_set_character_set() function. This function was added in MySQL 5.0.10

7.

Laravel cannot change the default encryption method?

Introduction: I want to replace the default bcrypt (password) with md5 (password+salt). Without changing the vendor file, I can only add a ServiceProvider myself. Replace the original. So I wrote an AddSaltHasher myself, but found that $salt could not be obtained in the make method. There was...

8.

mysqlChange the default character set_MySQL

Introduction: mysql changes the default character set

9.

Change the default value of a large table using alter table without rebuilding the table directly Modify .frm_MySQL

Introduction: To change the default value of a large table, use alter table without rebuilding the table, directly modify the .frm

10. Use jQuery to change the default alert frame_ jquery

Introduction: This article introduces how to use jquery to rewrite the Alert pop-up box style. It is very practical. I recommend it to everyone here. Friends in need can refer to it. .

[Related Q&A Recommendations]:

zsh - ubuntu Changing the default shell causes root su to be unable to log in?

nginx - php-fpm cannot start after changing the default port

##android-studio - android studio changes the default compiled version

How to change the default data display page in Weiphp.

javascript - How to change default file type in atom?

The above is the detailed content of Detailed information about changing the default. For more information, please follow other related articles on the PHP Chinese website!