飞鱼丶灬的博客

public com.xinyan.mp.base.connect.model.PageInfo<Map<String, Object>> pageQuery(DbSourcePageQueryReqDTO dbSourcePageQueryReqDTO) throws SQLException, ClassNotFoundException { String sql = dbSourcePageQueryReqDTO.getSql(); String

1.生成mysql 建表语句import com.alibaba.druid.sql.ast.SQLDataTypeImpl;import com.alibaba.druid.sql.ast.SQLIndexDefinition;import com.alibaba.druid.sql.ast.expr.SQLIdentifierExpr;import com.alibaba.druid.sql.ast.statement.SQLAssignItem;import com.alibaba.drui

赋权限GRANT ALL PRIVILEGES ON AI_MP_DOC.* TO root@’%’ IDENTIFIED BY ‘123456’;GRANT select,insert,update,delete,create,drop ON AI_MP_DOC.* TO root@’%’ IDENTIFIED BY ‘123456’;

第一步：安装与测试登陆1.安装yum -y install mariadb mariadb-server2.启动systemctl start mariadb3.进行MariaDB的相关简单配置,首先是设置密码，会提示先输入密码:输入: mysql_secure_installationEnter current password for root (enter for none): 【初次运行直接回车】4.设置密码Set root password? [Y/n] 【是否设置roo

调度中心支持多节点部署，基于数据库行锁，保证触发器的名称和执行时间相同，则只且仅有一个调度中心节点去下发任务给执行器。核心代码可见 XXL-JOB 的 JobScheduleHelper#start() 方法：// JobScheduleHelper.java// 获得行锁conn = XxlJobAdminConfig.getAdminConfig().getDataSource().getConnection();connAutoCommit = conn.getAutoCommit();

#查询执行计划show processlist;#kill 具体的IDkill 49886220;``

public class SourceManager{ static Pattern JDBC_PATTERN = Pattern.compile("jdbc:\\w+:\\/\\/\\d+\\.\\d+\\.\\d+\\.\\d+:\\d+\\/\\w+\\?*.*"); static Pattern ORACLE_JDBC_PATTERN = Pattern.compile("jdbc:oracle:thin:@\\d+\\.\\d+\\.\\d+\\.\\d+:\\d+:\\w+.*");

jdbc:mysql://127.0.0.1:3306/DEMO?tinyInt1isBit=false

Install MySQL and the MySQL community server, and start the MySQL service:yum localinstall \https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpmyum install mysql-community-server...