mariadb - Is it possible for another user to insert in the middle of a multi-value insert? -
is possible user insert in middle of multi-value insert?
multi-value insert mean:
https://mariadb.com/kb/en/mariadb/how-to-quickly-insert-data-into-mariadb/#multi-value-inserts
reason asking make sure auto-increment values multi-value insert serial , insert cannot insert value in middle them.
and insert cannot insert value in middle them
there's no table locking involved cannot assume this.
the reason asking make sure auto-increment values multi-value insert serial
what for? need unique taken care database. if rely on order of values looks architecture/design wrong @ point.
Comments
Post a Comment