Forum Moderators: open

Message Too Old, No Replies

Multiple insert locking question

do you need to lock table to ensure concurrent inserts

         

proper_bo

11:31 am on Jul 27, 2008 (gmt 0)

10+ Year Member




I am doing a MySQL insert that involves putting 4 new lines into a table.

My questions is simple.

To ensure the lines get concurrent id's (eg. 123,124,125,126) do I need to lock the table during insert or will this happen as standard?

Thank you.

eelixduppy

2:51 am on Jul 30, 2008 (gmt 0)



It should happen automatically, I believe. You shouldn't need to lock it.