MySQL Forums
Forum List  »  PHP

Re: How to lock and update data between two table in mysql
Posted by: Georg Richter
Date: April 02, 2006 01:30AM

You need a transactional storage engine like InnoDB or BDB. MyISAM will not work.

1) if the variables are from your tables, you should fetch the values first.
2) With COMMIT
3) WITH rollback

Make also sure that autocommit is off.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to lock and update data between two table in mysql
April 02, 2006 01:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.