传说中胖子

创建索引（MySQL 5.7.6后全文件索引可用WITH PARSER ngram，针对中文，日文，韩文）

select * from global_priv \G查询 ，root用户默认是unix_socker类型而解决方法很简单，只要输入如下命令即可ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("your_...

CREATE FUNCTION `getChildLst`(`rootId` INT) RETURNS VARCHAR(1000)BEGIN DECLARE sTemp VARCHAR(1000); DECLARE sTempChd VARCHAR(1000); SET sTemp = null; SET sTempChd =cast(rootId as CHAR); WHILE sTempChd is not null DO SET sTemp = concat_ws(',.

利用mysql事件定时自动执行BEGIN set @table_name = concat('p', DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 DAY),'%Y%m%d')); set @max_value = DATE_FORMAT(DATE_ADD(NOW(),INTERVAL 1 DAY),'%Y%m%d'); set @excutesql = CONCAT('ALTER TABLE 表名 ADD PARTITION (PARTITION ',@ta.