SQL statement has the same field calls two Max function will be different?-CodePudding

Home > database > SQL statement has the same field calls two Max function will be different?

SQL statement has the same field calls two Max function will be different?

Time：05-20

For example: insert into test (id, name) select (select ifnull (Max (id), 0) + 1 from test), 'li Ming' where not the exists (select 1 from the test where id=(select ifnull (Max (id), 0) + 1 from test))
This statement has two local call Max function, in the case of high concurrency Max (id) inconsistent would happen?

Page link：https//www.codepudding.com/database/111659.html

Prev:The ACCESS not repeat count

Next:Different tag search more time complexity and space complexity of the algorithm is what?

Tags：

MySQL

Links：
CodePudding