Mr. Zawodny is right MyISAM natively does not support Transactions, but Transactions can be done with a set of myISAM tables and a lot of code specific to supporting transactions w/o a race condition. Basically it's a long a tedious process of writing code to support a "ticket server" (a unique id for every row in any table separated out into a different table or database), then use this to simulate a commit and rollback. If you go this route (don't: use INNODB) you'll have to worry about race conditions, bugs etc.
-----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:48 PM To: Nitin Nanivadekar Cc: [EMAIL PROTECTED] Subject: Re: Transaction Support with MyISAM On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote: > Dear Friends, > > The last help I got was truly worth a zillion. Such a bargin! > 1. How can i have commit/rollback functions using > MyIsam database which is default database engine for > MySql? i am using vb You cannot. MyISAM tables are not transactional. BDB and InnoDB are. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 51 days, processed 1,775,767,802 queries (396/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
