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

Question

If two connections are inserted into the same table at exactly the same time in one ten thousandth of a millisecond or one millionth of a millisecond, can they be inserted 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 1

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

Answer 2

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