//查重
    select from MAGPIE.MP_METER a where (a.USER_CODE) in (select USER_CODE from MAGPIE.MP_METER group by USER_CODE having count() > 1)

    oracle 恢复删除的数据
    select * from FS_METER_SPEC as of timestamp to_timestamp (‘2022/04/24 14:27:00’,’yyyy-mm-dd hh24:mi:ss’)

    insert into FISH_KOI_3.FS_METER_SPEC (select * from FISH_KOI_3.FS_METER_SPEC as of timestamp to_timestamp (‘2022/04/24 14:27:00’,’yyyy-mm-dd hh24:mi:ss’))

    MySQL8.0连接后缀：

    1. ?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true&nullCatalogMeansCurrent=true&serverTimezone=Asia/Shanghai

    MySQL修改数据库-数据表的字符集

    修改数据库的字符集
alter database xxx charset utf8
修改表的字符集
alter table xxx charset utf8