MySQL表名转大写

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
DELIMITER //
CREATE DEFINER=`root`@`localhost` PROCEDURE `p_Uppercase`(IN `dbname` varchar(200))
BEGIN
DECLARE done INT DEFAULT 0;  
 
DECLARE oldname VARCHAR(200);  
 
DECLARE cur CURSOR FOR SELECT table_name FROM information_schema.TABLES WHERE table_schema = dbname;  
 
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;  
 
OPEN cur;  
 
REPEAT  
 
FETCH cur INTO oldname;  
 
SET @newname = UPPER(oldname);  
SET @isNotSame = @newname <> BINARY oldname;  
IF NOT done && @isNotSame THEN  
SET @SQL = CONCAT('rename table `',oldname,'` to `', LOWER(@newname), '_tmp` ');  
PREPARE tmpstmt FROM @SQL;  
EXECUTE tmpstmt;  
 
SET @SQL = CONCAT('rename table `',LOWER(@newname),'_tmp` to `',@newname, '`');  
PREPARE tmpstmt FROM @SQL;  
EXECUTE tmpstmt;
 
DEALLOCATE PREPARE tmpstmt;  
 
END IF;  
UNTIL done END REPEAT;  
CLOSE cur;  
END//
DELIMITER ;

 

Docker 部署 Net Core

一、docker 安装及设置

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#安装 CentOS已经将Docker软件包放在了Extras软件源中，直接利用即可
yum install docker-io -y
 
#查看docker的版本 version
docker -v
 
#开启Docker服务
systemctl start docker.service
 
#开机启动Docker服务
systemctl enable docker.service
 
#查看Docker服务启动状态
systemctl status docker.service
 
#重启Docker服务
systemctl restart docker.service

  […]