WKL_J的博客

select date_add(curdate(), interval(cast(help_topic_id as signed integer) - DATE_FORMAT( DATE_SUB( curdate( ), INTERVAL 1 DAY ), ‘%d’ )) day) date from mysql.help_topic where help_topic_id < day(last_day(curdate())) #获取所有当前月日期 #help_topic_id<day(cur

*********************** set global log_bin_trust_function_creators=TRUE; 开启bin_log 有时没有这一句会创建不了 DROP FUNCTION IF EXISTS 函数名; DELIMITER CREATEFUNCTION‘函数名‘(‘参数‘varchar(5))−−varchar后面一定要带长度（浪费好长时间）RETURNSvarchar(255)BEGINRETURN′sdsd′;END CREATE FUNCTION `.

https://blog.csdn.net/Let_me_tell_you/article/details/80941301转载

1、使用show engines;命令查看federated引擎是否开启 2、如果没开启在my.ini中[mysqld]标签下下直接加上一行 federated重启数据库服务 3、开始建立： CREATE TABLE 表名 ( 字段 varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci PRIMARY KEY (orgid) USING BTREE ) ENGINE=FEDERATED CONNECTION=‘mysql://username:pas