In a mysql table, is it possible to insert data into multiple connections at the same time?

Question

If at one ten thousandth of a millisecond or one millionth of a millisecond, at exactly the same moment, can two connections perform insert into the same table at the same time? When modifying a data table, can two connections modify the same data table (different rows) at exactly the same time?

某草草 · Answer

You have to look at the locking mechanismmysql用的什么引擎了，不同引擎的锁机制是不一样的，现在主流是innodb，你可以网上看看innodb

过去多啦不再A梦 · Answer

Of course you can, otherwise why would you need to lock it