查询表信息插入另一张表
- Insert into data_dictionary(GMT_CREATED,GMT_MODIFIED,GROUP_NAME,KEY_NAME,KEY_VALUE)
- (
- select
- CURRENT_TIMESTAMP,CURRENT_TIMESTAMP,'SYNCEXAMREPORTGROUPNAME','EXAMREPORTID',report_id
- from report_baseinfo
- where exam_company='XXX有限公司'
- );
-