> Hello All, > I would like to know the some details regarding the transaction > support in Mysql Version 4. May i know where can i find the related > stuffs.
Transactions are supported in the current 3.23.53 release of MySQL-Max and MySQL 4 (Pro version I think) with the InnoDB table type. You will need to read up on the InnoDB table type (see http://www.mysql/doc). Basically you will need to create a my.cnf file to create some space for your InnoDB tables, then create tables in mysql with: CREATE TABLE mytable (....) TYPE=InnoDB; Then you can use transactions: BEGIN; INSERT INTO mytable ... ; UPDATE mytabe ... ; DELETE FROM mytable ... ; COMMIT; or ROLLBACK; www.mysql.com/doc and search for InnoDB or transaction! Have fun, Josh --------------------------------------------------------------------- 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