CREATE PROCEDURE insert_and_back(in sqlStr VARCHAR(4000), in backSql VARCHAR(4000))
BEGIN
set @sql = sqlStr;
PREPARE stmt from @sql;
EXECUTE stmt;
set @sql = CONCAT(backSql,@@identity);
PREPARE stmt from @sql;
EXECUTE stmt;
END
MySQL存储过程-插入后返回ID
最新推荐文章于 2024-05-23 15:06:00 发布