在多行插入中使用LAST_INSERT_ID() [英] Using LAST_INSERT_ID() within a multi row insert

问题描述

是否可以在插入查询中使用LAST_INSERT_ID()?

Is it possible to use LAST_INSERT_ID() within an insert query?

INSERT INTO mytable (col1, col2) VALUES ('val1', null), ('val2', LAST_INSERT_ID())

尝试上面的LAST_INSERT_ID()返回0，只是看看我是否可以组合查询.

Trying the above LAST_INSERT_ID() returns 0, Just seeing if i can combine the query.

推荐答案

从我的发现来看，它是无效的，因为LAST_INSERT_ID在整个语句完成之前没有值.

From what i found it won't work as LAST_INSERT_ID doesn't have a value until the whole statement has finished.

这篇关于在多行插入中使用LAST_INSERT_ID()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！