On Thursday, March 14, 2002, at 11:12 PM, Chris Stark wrote: > "This statement signals the successful end-of-transaction. A transaction > is > a group of SQL statements whose changes are logically connected and can be > made permanent or undone as a unit. All updates made during this > transaction are made permanent, all row locks are released, and active SQL > SELECT statements are closed." > > I got that quote from Oracle... > > I think it is the same as the COMMIT command in MySQL!!
Since different databases add their own extensions to SQL, applying definitions from one database to another can get you into some fairly confusing situations. For MySQL, in a nutshell: 1) This only applies if you are using transactional table types (BDB, InnoDB, Gemini). If you are not using those table types (using ISAM or MyISAM for example), begin work and commit will do nothing for you. 2) With autocommit off, you start transactions with "begin work" you end transactions with "commit" or "rollback". If you "begin work" and then "begin work" again, the first transaction is implicitly committed. Read the manual: Notably Section 7.5.4 on InnoDB David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
