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
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
e 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 m
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)