排序
CDC变量数据捕获组件
canal: https://github.com/alibaba/canal flink cdc: https://ververica.github.io/flink-cdc-connectors/ https://gitcode.com/mirrors/ververica/flink-cdc-connectors Debezium: https://de...
SQL字符串操作,替换身份证为掩码
SELECT UPPER(CONCAT( LEFT ( staffer_code, 6 ), '****', RIGHT ( staffer_code, 4 ) )) AS 身份证号 FROM sys_user where TRIM(staffer_code)<>''
MySQL备份
一个多表备份的脚本例子: #/bin/bash # 初始化变量 user=root password=123456 backup_dir='/data/mysql_backup' time='$(date +'%Y%m%d_%H%M%S')' data_file='$backup_dir/meter_copy_center'...
MySQL 慢查询
查看是否开启慢查询: show variables like 'slow_query_log'; 设置慢查询时间: set global long_query_time = 2; 查看是否开启未使用索引查询: show variables like 'log_queries_not_using_...
mysql行数据查重的例子
查重的例子: select CONCAT('\'',id,'\',') from meter_copy_data_water where (meter_id,copy_time) in (select t.meter_id,t.copy_time from meter_copy_data_water t GROUP BY t.meter_id,t...
数据库表结构导出工具database-export
gitee源代码: https://gitee.com/pomz/database-export 运行方法: java -jar database-export-x.x.x.jar 访问地址:http://localhost:9999/dbExport/ 或http://localhost:9999/dbExport/v1 (...