MyISAM 表使用表级锁定.这意味着在执行更新查询期间将锁定整个表.所以你的简化用例的答案是:是的，这是线程安全的.但如果您使用其他存储引擎或您的更新包含多个表，则情况可能并非如此.

MyISAM tables use table level locking. This means that the whole table will be locked during the execution of your update query. So the answer for your simplified use case is: yes, this is thread safe. But this may not be the case if you use another storage engine or your update includes multiple tables.

为了更清楚，这里引用了 MySQL 手册:

Here is a quote from the MySQL manual for more clarity:

表锁定使许多会话能够同时从表中读取，但是如果一个会话想要写一个表，它必须首先获得独占使用权.在更新期间，所有其他想要访问这个的会话特定的表必须等到更新完成.

Table locking enables many sessions to read from a table at the same time, but if a session wants to write to a table, it must first get exclusive access. During the update, all other sessions that want to access this particular table must wait until the update is done.

如果适合您的设计，您还可以考虑使用自动增量列、事务或外部同步.

You can also consider using auto increment columns, transactions or external synchronization if that fits to your design.

干杯！