SET @tableName = concat('nontax_t_crj_share_',YEAR(NOW()));
SET @sql = CONCAT('SELECT COUNT(*) AS COUNT FROM ', @tableName, ' WHERE VERIFY_TIME like ?');
PREPARE stmt FROM @sql;
SET @param_value = concat(DATE(NOW() - INTERVAL 2 DAY),'%');
EXECUTE stmt USING @param_value;
在Navicat中执行mysql的动态sql
最新推荐文章于 2024-04-16 01:08:37 发布