Re: orderid with point of sale application
If you use InnoDB or BDB as the storage engine for the tables, you can combine both statements in a transaction. Then the row is implicitly locked until you commit.
If you use MyISAM, you need to lock the whole tables: LOCK TABLE restaurant WRITE, orders WRITE; <your statements here>; UNLOCK TABLES;
Regards
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
2883
April 19, 2006 04:04PM
1939
April 19, 2006 04:12PM
1702
April 23, 2006 04:27PM
1665
April 24, 2006 11:51AM
Re: orderid with point of sale application
1741
April 25, 2006 04:24AM
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.