Zhou_Andy的专栏

1.Mysql中tinyint(1)可以用作与Java类型中Boolean对应的字段。select true,TRUE,false,FLASE;  -->> 1,1,0,0设置成tinyint(1)的字段会自动映射为boolean类型（jFinal已验证)

set max_sp_recursion_depth=255;call showChildLst(56);DROP PROCEDURE IF EXISTS `createChildLst`;delimiter ;;CREATE DEFINER=`root`@`localhost` PROCEDURE `createChildLst`(IN pid INT,IN nDepth INT)

1.开启binlog（默认是不开启的）Windows:安装目录或c:\windows\system32\my.ini[mysqld]# Uncomment the following if you want to log updateslog-bin=mysql-binLinux/etc/my.cnf[mysqld] 下增加一行log-bin=mysqlbi

1、安装MySQL 5.7 serveryum list installed | grep mysqlyum -y remove mysql-libs.x86_64wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpmyum localinstall mysql-community-release-el6-5.

1、手动写一个监控脚本vim /usr/local/etc/checkmysql.sh#!/bin/shMYSQL_SOCK="/var/lib/mysql/mysql.sock"ARGS=1if [ $# -ne "$ARGS" ];then echo "Please input onearguement:"ficase $1 in Uptime)