SET @sqlstr=CONCAT("GRANT SELECT,INSERT,UPDATE,DELETE ON `adzone_", @lastDateTime, "` TO bdm@'%';");
INSERT INTO trans_sql_log(txt, create_date) VALUES(@sqlstr, NOW());
PREPARE stmt FROM @sqlstr;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET @sqlstr=CONCAT("GRANT SELECT,INSERT,UPDATE,DELETE ON `adzone_", @lastDateTime, "` TO bdm@'%';");
INSERT INTO trans_sql_log(txt, create_date) VALUES(@sqlstr, NOW());
PREPARE stmt FROM @sqlstr;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;