最新动态

CREATE TRIGGER new1 AFTER INSERT ON xs FOR EACH ROW SELECT ‘product added’#CREATE TRIGGER创建触发器语句的方法#new1为新触发器的名字#在操作AFTER INSERT命令成功后执行触发器#触发器指定FOR EACH ROW#插入文本打印DROP TRIGGER new1#删除触发器CREATE TRIGGER new1 BEFORE DELETE ON cc FOR EACH ROW BEGIN INSERT INT

import osimport sys#引入模块if len (sys.argv) < 2:#判断参数是否小余2    filepath="."eles:    filepath=sys.argv[1]#将argv赋值给变量for root,dirs,files in files in os.walk(filepash):#使用os.walk遍历文件目录    for filename in files:    &nbs

pip install request#安装包----------------------from urllib import request#引入模块url = "http://www.163.com"#抓取的网页地址wp = request.urlopen(url)#打开链接content = wp.read()#获取页面内容fp = open("d:/www.txt","w+b")#open打开文件用的是‘W+B’以二进制方式打开fp.write(content)#写入数据fp.close()#关闭

C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\Scripts#打开python文件目录，复制路径到，计算机属性环境变量path里面粘贴进去打开cmdpip install pymysql#安装mysql-----------------------------------------------------------------------------import pymysql#引入模块conn = pymysql.c

import ospath = input("请输入文件路径（结尾加上/）:")f= os.listdir(path)n =0for i in f:    oldname=path+f[n]    newname=path+"888"+str(n+1)+'.jpg'    os.rename(oldname,newname)    print(oldname,"=======>",newname)   

上传centos镜像wget ftp://10.32.18.211/paas/images/centos_latest.tar ; docker load < centos_latest.tar ; docker tag ID centos:latest ; ======================dockerfile============================mkdir dockerfile ; cd dockerfile;cat

delimiter //              #解释符号CREATE PROCEDURE one()    #储存为one的方法beginselect avg(nl) from xs;   #求nl列的平均数，从xs表中end //delimiter ;          #模式转换，分号有空格call one();   

alter table eisc add xb char(10); 动态#新建一个xb的列#-----------------------------------------alter table eisc drop column xb;#删除一个xb的列#----------------------------------------update eisc set xb =999 where id =1;#更新eisc表中的xb的列的id为1的数据alter table js add cons

M版脚本iaas脚本文件路径：usr/local/bin#/bin/bash# -*- coding:utf-8 -*-  #controller节点#--------服务进程出现问题卸载运用重来----#----------yum history undo -y 10wget http://www.eisc.cn/yunpingtai/jiaoben/jiaoben.tar.gz ; wget http://www.eisc.cn/yunpingtai/jiaoben/ce

安装首先检测是否安装mysql:rpm -qa | grep mysql如果有的话，将其卸载：rpm -e --nodeps mysql  //强力卸载yum install mysqlyum install mysql-server yum install mysql-devel     //安装MySQL如果在安装 mysql-server 出现了：No package mysql-server available.解决：先检测是否安装wget：输入wget如果