摘要：Docker安装及管理yum install docker-io -yvim /etc/sysconfig/docker#修改静像获取源地址other_args="--registry-mirror=https://wgcscytr.mirror.aliyuncs.com" docker searc 阅读全文

摘要：1、主节点配置：yum install mariadb-server.x86_64 -y#安装数据库service mariadb start#启动数据库mysql -uroot -p123456#登录数据库创建从节点连接登录用户create user 'repl'@'192.168.2.%' id 阅读全文

摘要：yum安装yum install mariadb-sreverrpm -ql mariadb-serverss -ntl#查看端口运行状态，3306端口ss -utlnpservice mariadb start#启动mysqlmysql#连接到数据show　databases；#查看数据库use　 阅读全文

摘要：1、运行：yum-yinstallmysql-servermysqlmysql-devel2、启动或停止mysql服务：servicemysqld start/stop3、创建root管理员：mysqladmin-urootpassword1234564、登录mysql数据库：mysql -u ro... 阅读全文

摘要：DROP procedure IF EXISTS _GetMaxId;CREATE PROCEDURE _GetMaxId()BEGIN SELECT MAX(Id) FROM ;END;DROP procedure IF EXISTS _Exists;CREATE PROCEDURE _Exists($_Id int)BEGIN SELECT count(1) FROM WHERE Id=$_Id ;END;DROP procedure IF EXISTS _ADD;CREATE PROCEDURE _ADD( OUT $_ (),$_ $_ (),) BEGIN INSERT ... 阅读全文

摘要：DROP TABLE IF EXISTS `bank_ums`.`ums_file`;CREATE TABLE `bank_ums`.`ums_file` ( `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '标识', `fileName` varchar(200) DEFAULT NULL COMMENT '文件名', `filePath` varchar(500) DEFAULT NULL COMMENT '文件地址', `fileDescribe` varchar(250) DEFAULT NULL 阅读全文

摘要：将下载压缩包解压到任意目录配置安装文件：# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the# *** default location during install, and will be replaced if you# *** upgrade 阅读全文

摘要：CREATE PROCEDURE p25 (OUT return_val INT)BEGINDECLARE a,b INT;DECLARE cur_1 CURSOR FOR SELECT s1 FROM t;DECLARE CONTINUE HANDLER FOR NOT FOUNDSET b = 1;OPEN cur_1;REPEATFETCH cur_1 INTO a;UNTIL b = 1END REPEAT;CLOSE cur_1;SET return_val = a;END; 阅读全文

摘要：mysql 1045 access denied for user 解决方法命令行中修改密码：mysql -u rootmysql> use mysql;mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root'... 阅读全文

摘要：创建存储过程：CREATEPROCEDURE '存储过程名'(_field varchar(400),_table varchar(50),_whe varchar(200),_begin int,_amount int)BEGINdeclare sSqlvarchar(4000);set sSql=concat('select ',_field,' from ',_table,' where ',_whe,' limit ',_begin,',',_amount);set @qstr=sSql;p 阅读全文