Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Start a New Transaction Explicitly
How To Start a New Transaction Explicitly? - MySQL FAQs - Transaction Management: Commit or Rollback
✍: FYIcenter.com
If you are confused on the implicit new transaction rules, you can always start a new transaction with the "START TRANSACTION" command to start a new transaction explicitly. "START TRANSACTION" command works in both "Autocommit On" and "Autocommit Off" modes.
The following tutorial exercise shows you how to start a transaction explicitly:
>\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> ROLLBACK; Query OK, 0 rows affected (0.07 sec)
2007-05-11, 4934👍, 0💬
Popular Posts:
What Happens If a Hyper Link Points to a Music File? - XHTML 1.0 Tutorials - Understanding Hyper Lin...
How To Remove the Top White Space of Your Web Page? - CSS Tutorials - Introduction To CSS Basics The...
How To Check the Oracle TNS Settings? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Con...
How To Export Data to an XML File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you wa...
How can I implement a thread-safe JSP page? You can make your JSPs thread-safe by having them implem...