Collections:
Commit the Current Transaction in MySQL
How To Commit the Current Transaction in MySQL?
✍: FYIcenter.com
If you have used some DML statements updated some data objects, and you want to have the updates to be permanently recorded in the database, you can use the COMMIT command. It will make all the database changes made in the current transaction become permanent and end the current transaction. The following tutorial exercise shows you how to use COMMIT commands:
>\mysql\bin\mysql -u dev -piyf fyi mysql> START TRANSACTION; Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO fyi_links (url, id) VALUES ('fyicenter.com', 101); Query OK, 1 row affected (0.11 sec) mysql> INSERT INTO fyi_links (url, id) VALUES ('centerfyi.com', 110); Query OK, 1 row affected (0.00 sec) mysql> SELECT * FROM fyi_links; +-----+---------------+-------+--------+-------------------- | id | url | notes | counts | created +-----+---------------+-------+--------+-------------------- | 101 | fyicenter.com | NULL | NULL | 2006-07-01 20:27:49 | 110 | centerfyi.com | NULL | NULL | 2006-07-01 20:28:10 +-----+---------------+-------+--------+-------------------- 2 rows in set (0.07 sec) mysql> COMMIT; Query OK, 0 rows affected (0.04 sec)
⇒ Rollback the Current Transaction in MySQL
⇐ Start a New Transaction Explicitly in MySQL
2016-10-17, 1378🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...