qq_36249659的博客

update test set content=CONCAT(content,"123456") where title="'.$content['title'].'"';

delimiter $ 修改定界符//创建存储过程create procedure p1()beginselect * from salary;end$//调用存储过程call p1()$//查看已经有的存储过程show procedure status$//删除drop procedure sp_name//引入变量create procedure p1()beg...

//行级触发器for each row//创建一个触发器create trigger t1afterinserton ordfor each rowbeginupdate goods set stock=stock-2 where id=1;end$//查找触发器show triggers//删除触发器drop trigger triggerName//触发器传参数...

//在这个目录下cd /usr/local/src//nginxwget http://nginx.org/download/nginx-1.12.2.tar.gz//安装pcre zlibwget https://ftp.pcre.org/pub/pcre/pcre-8.37.tar.gzwget http://zlib.net/zlib-1.2.11.tar.gzcd 到...

主服务器配置:显示主服务器状态:show master status;vim /etc/my.cnf//给服务器一个idserver-id=201//声明2进制日志的文件夹为 mysql-bin.xxxxlog-bin=mysql-bin//二进制日志的格式 mixed/row/statementrow:磁盘变化少,语句长statement:磁盘变化大,语句短mixed:混合...

只需把 /etc/my.cnf 中的bind-address 改为bind-address=0.0.0.0

reset mastermysql 重启：/etc/init.d/mysql restart