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