WKL_J的博客

select date_add(curdate(), interval(cast(help_topic_id as signed integer) - DATE_FORMAT( DATE_SUB( curdate( ), INTERVAL 1 DAY ), ‘%d’ )) day) datefrom mysql.help_topicwherehelp_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′;ENDCREATE FUNCTION `.

https://blog.youkuaiyun.com/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_ciPRIMARY KEY (orgid) USING BTREE) ENGINE=FEDERATEDCONNECTION=‘mysql://username:pas