将quartz的表,转为对应的大写

最新推荐文章于 2023-11-23 14:44:35 发布

TomcatLikeYou

最新推荐文章于 2023-11-23 14:44:35 发布

阅读量273

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/qq_37293230/article/details/133949924

版权

SELECT table_name  
FROM information_schema.tables  
WHERE table_schema = 'etl' AND table_name LIKE 'qrtz%';
ALTER TABLE `etl`.`qrtz_blob_triggers` RENAME TO  `etl`.`QRTZ_BLOB_TRIGGERS` ;
ALTER TABLE `etl`.`qrtz_calendars` RENAME TO  `etl`.`QRTZ_CALENDARS` ;
ALTER TABLE `etl`.`qrtz_cron_triggers` RENAME TO  `etl`.`QRTZ_CRON_TRIGGERS` ;
ALTER TABLE `etl`.`qrtz_fired_triggers` RENAME TO  `etl`.`QRTZ_FIRED_TRIGGERS` ;
ALTER TABLE `etl`.`qrtz_job_details` RENAME TO  `etl`.`QRTZ_JOB_DETAILS` ;
ALTER TABLE `etl`.`qrtz_locks` RENAME TO  `etl`.`QRTZ_LOCKS` ;
ALTER TABLE `etl`.`qrtz_paused_trigger_grps` RENAME TO  `etl`.`QRTZ_PAUSED_TRIGGER_GRPS` ;
ALTER TABLE `etl`.`qrtz_scheduler_state` RENAME TO  `etl`.`QRTZ_SCHEDULER_STATE` ;
ALTER TABLE `etl`.`qrtz_simple_triggers` RENAME TO  `etl`.`QRTZ_SIMPLE_TRIGGERS` ;
ALTER TABLE `etl`.`qrtz_simprop_triggers` RENAME TO  `etl`.`QRTZ_SIMPROP_TRIGGERS` ;
ALTER TABLE `etl`.`qrtz_triggers` RENAME TO  `etl`.`QRTZ_TRIGGERS` ;