You usually use begin work before a bunch of inserts or deletes from a database....
i.e. BEGIN WORK INSERT .... INSERT .... DELETE .... INSERT .... . . . COMMIT WORK OR ROLLBACK WORK It is the start of a transaction and it allows you to guarantee some of the ACID properties of your database... Chris -----Original Message----- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 12:33 AM To: Chris Stark Subject: Re: Begin work Where "Begin work" Works process used mainly. Manish ----- Original Message ----- From: Chris Stark <[EMAIL PROTECTED]> To: Manish Mehta <[EMAIL PROTECTED]>; mysql <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 10:42 AM Subject: RE: Begin work > "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!! > > Chris > > -----Original Message----- > From: Manish Mehta [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 15, 2002 12:07 AM > To: mysql > Subject: Begin work > > > Hi > > Any body tells me what the use of "Begin work" in SQL . > > Manish Mehta > > > > --------------------------------------------------------------------- > 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 > > > --------------------------------------------------------------------- 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
