Use the from insert into multiple tables, found from time to time will lock table, partition and lock the entire table, cause the failure of the query, this is how to return a responsibility? At the same time also can not insert into different partitions data? How to set price lock table in the division, and don't lock the entire table?

CodePudding user response:

The lock table level, a typo