Before commiting the transaction, what happens to the queries on a tables which are being used in that transaction?

I have a situation where I need to lock 2 tables, until some operations are done on those 2 tables individually. For that I have chosen "TRANSACTIONS". So, between "START TRANSACTION" and "COMMIT".. if anyone tries to insert into those tables, what happens to those queries? will they be maintained in the queue and will be execut开发者_运维问答ed after the transaction is completed? Ideally, whats my requirement is.. they should not get inserted until my transaction has got commited.

Please anyone tell me the scenario.

Thanks in advance! SuryaPavan

When a transaction is initiated, it's isolated from the rest of the world. That's the I in ACID.

During the transaction, if anyone tries to insert anything - the insert will occur but it won't break the transaction you are performing in any way. Same rule applies in the other direction.

If you have the requirement to literally lock the entire table for insert until your transaction succeeds - that smells like a bad design and you should reconsider if what you're doing is really optimal.

If they got inserted before your transaction was committed (that is, in the middle of your transaction), that would make transactions fairly useless.

I assume you're using mysql (since your question is tagged with that)... why not open two command line sessions to your database and try it to see what happens? That would take far less time than posting your question and waiting for an answer, and you'll likely learn more in the process.