HzqGhost's Blog

ProxySQL有配置文件/etc/proxysql.cnf和配置数据库文件/var/lib/proxysql/proxysql.db。如果想要让proxysql.cnf文件里的配置在重启proxysql服务后生效(即想要让proxysql重启时读取并解析proxysql.cnf配置文件)，则需要先删除/var/lib/proxysql/proxysql.db数据库文件，然后再重启proxysql服务。编辑 /etc/proxysql.cnf 文件配置 ProxySQL。ProxySQL配置。

【代码】MYSQL JSON。

【代码】MySQL FEDERATED。

MySQL8 免安装版安装。

DELIMITER $$CREATE DEFINER=`root`@`%` EVENT `event_hour` ON SCHEDULE EVERY 1 HOUR STARTS '2022-02-23 01:00:00' ON COMPLETION PRESERVE ENABLE COMMENT '每小时' DO BEGINSET @hour = CONVERT(DATE_FORMAT(NOW(),'%k'), UNSIGNED INTEGER);IF @hour>6 AND @hour&l.

DELIMITER $$USE `money`$$DROP FUNCTION IF EXISTS `getObjectFullName`$$CREATE DEFINER=`root`@`%` FUNCTION `getObjectFullName`(id INT) RETURNS VARCHAR(255) CHARSET utf8BEGIN DECLARE fullname VA...

功能有误的(大数据情况下)：select * from table where id not in (values);正常的(适用大数据)select * from table where id not in (select id from subtable)从5.0 开始支持子查询

建立CREATE  TRIGGER 触发器名 AFTER INSERT ON 表  FOR EACH ROW begininsert into state_pro_update setpid = New.id,Operation = N;end; 动作时间BEFORE或AFTER 动作 INSERT,UPDATE, DELETE.对应ROWINSERT 

<br />添加外键<br />ALTER TABLE data ADD CONSTRAINT data_fk_pack_in<br />FOREIGN KEY (pack_in)<br />REFERENCES package_io_link(in_id)<br />on delete set Default on update no action; <br /> <br />建表时创建<br />create table temp( <br />id int, <br />name char(20),