In the article, I will explain What is Transaction in MySQL. Also, article contains information about the use of Transaction, which is frequently used in systems such as SQL Server, Oracle etc..<\/p>\n
Transaction is a feature that allows database management systems to perform transactions according to ACID rules Transaction provides integrity, consistency, independence and durability in ACID rules. Thus, data is restored when errors occur during any change.<\/p>\n
The INNODB storage engine is used to use the Transaction feature with MySQL. Let’s create the products table where the products are stored.<\/p>\n
CREATE TABLE products (\n product_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n product_name VARCHAR(255) NOT NULL,\n product_price DECIMAL(10,0) NOT NULL\n) ENGINE=INNODB;<\/pre>\nBEGIN TRANSACTION in MySQL<\/h3>\n
One of the following is applied to start the transaction.<\/p>\n
START TRANSACTION;<\/pre>\nor<\/p>\n
BEGIN;<\/pre>\nSQL commands executed after the Transaction feature is started cannot perform any inserts, deletes or updates on the table.<\/p>\n
The transactions performed are temporarily stored in memory.<\/p>\n
COMMIT and ROLLBACK Transaction in MySQL<\/h3>\n
To reflect the transactions performed within the transaction to the table, below command is used.<\/p>\n
COMMIT;<\/pre>\nTo rollback the transactions performed within the transaction, below command is used.<\/p>\n
ROLLBACK;<\/pre>\nThe Transaction feature is mostly used within MySQL stored procedures with the MySQL if statement for error checking. With the MySQL if statement, errors are checked, and as a result, transactions are committed to the table or rolled back.<\/p>\n
I wish you a good day.<\/p>\n
<\/div>\n