SET @sqlcmd = concat('delete from ', milestone,' WHERE id= ',milestoneid); prepare stmt from @sqlcmd; execute stmt; deallocate prepare stmt;
msyql存储过程使用传入的参数作为表名称
最新推荐文章于 2021-01-20 13:21:50 发布
SET @sqlcmd = concat('delete from ', milestone,' WHERE id= ',milestoneid); prepare stmt from @sqlcmd; execute stmt; deallocate prepare stmt;