MySQL存储过程-插入后返回ID

来源:互联网 发布:陌陌网络主播收入 编辑:程序博客网 时间:2024/05/16 23:36
CREATE PROCEDURE insert_and_back(in sqlStr VARCHAR(4000), in backSql VARCHAR(4000))BEGINset @sql = sqlStr;PREPARE stmt from @sql;EXECUTE stmt;set @sql = CONCAT(backSql,@@identity);PREPARE stmt from @sql;EXECUTE stmt;END