查看是否开启 show variables like ‘%sche%’; 开启 set global event_scheduler =1; 查看已经存在的定时任务 SELECT * FROM information_schema.EVENTS; use database; create event test on schedule every 60 second do [something]; UPDATE `Files` SET `usr_id`=8362 WHERE `usr_id`=0 AND `file_created` BETWEEN ‘2018-01-16 00:00:00.000000’ AND ‘2019-01-02 08:00:00.000000’ via https://segmentfault.com/a/1190000005142597
. Read more
Exchange webmoney and paypal http://exwp.com/index_en.html 汇率最佳，24h到帐，已兑换1500 WMZ Exchange BTC to WMZ https://btc2wm.me/ BTC to CNY https://www.alfacashier.com/ BTC to CNY https://www.megachange.is/en/
. Read more
Ubuntu 16.04.2 LTS sudo apt-get update sudo apt-get install apache2 sudo systemctl restart apache2 sudo apt-get install mysql-server mysql_secure_installation sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql sudo apt install unzip #sudo apt-get install php-mbstring cd /var/www/html/ wget https://files.phpmyadmin.net/phpMyAdmin/4.7.6/phpMyAdmin-4.7.6-all-languages.zip unzip -x *.zip mv phpMyAdmin-4.7.6-all-languages phpmyadmin sudo systemctl restart apache2 /sbin/iptables -I INPUT -p tcp –dport 3306 […]
. Read more
Centos 6 矿池:xmr.nanopool.org yum -y install epel-release yum -y install centos-release-scl cmake3 hwloc-devel libmicrohttpd-devel openssl-devel yum -y install devtoolset-4-gcc* yum -y install git scl enable devtoolset-4 bash git clone https://github.com/fireice-uk/xmr-stak-cpu xmr-stak cd xmr-stak #调整百分之二的开发者捐赠 sed -i ‘s/2.0/0.0/g’ donate-level.h cmake3 . make install cd /root/xmr-stak/bin 先运行一遍 ./xmr-stak-cpu 会给出推荐的CPU配置信息，将它编辑进config.txt，并填写钱包地址、矿池地址、Payment ID等信息 httpd_port 设置http访问端口，可以用网页查看矿机状态 “cpu_threads_conf” : [ { “low_power_mode” […]
. Read more
wget http://update.aegis.aliyun.com/download/quartz_uninstall.sh chmod +x quartz_uninstall.sh ./quartz_uninstall.sh rm -f /usr/sbin/aliyun-service rm -rf /usr/local/aegis killall -9 aliyun-service > /dev/null 2>&1
. Read more
zip.exe和unzip.exe下载 放到C:\Windows\System32 下面 source =r’E:\111\test’ target_dir = ‘E:\\111\\’ targetr = target_dir + ‘test.rar’ rar_command = ‘rar a {0} {1}’.format(targetr,source) if os.system(rar_command) ==0: print(“Successful rar to”,targetr) else: print(“RAR FAILED”) targetz = target_dir + ‘test.zip’ zip_command = ‘zip -r {0} {1}’.format(targetz,source) if os.system(zip_command) ==0: print(“Successful zip to”,targetz) else: print(“ZIP FAILED”)
. Read more
speedtest_cli wget -O speedtest-cli http://linux.dog/speedtest_cli.py chmod +x speedtest-cli ./speedtest-cli
. Read more
1. 直接在命令行用pip安装 pyinstaller pip install pyinstaller 2. 下载安装pyinstaler运行时所需要的windows拓展—pywin32 pywin32:http://sourceforge.net/projects/pywin32/files/pywin32/ 点击最新的Build再点击pywin32-219.win-amd64-py2.7.exe(这里要根据你的windows x86或者x64和你的python版本来选择) 3.在命令行中切换到要打包的程序所在目录,直接输入下面的指令即可 pyinstaller -F -w demo.py Via
. Read more
import os import shutil from PIL import Image dir0=str(os.getcwd()).replace(‘\\’,’/’) print(dir0) lista = os.listdir(dir0) print(lista) list2=[] for lsa in lista: print(dir0+’/’+lsa) print(os.path.isdir(dir0+’/’+lsa)) if os.path.isdir(dir0+’/’+lsa): list2.append(lsa) print(list2) for ls2 in list2: inlist2 = os.listdir(dir0+’/’+ls2) print(inlist2) for inls2 in inlist2: print(dir0+’/’+ls2+’/’+inls2) print(os.path.isdir(dir0+’/’+ls2+’/’+inls2)) if os.path.isdir(dir0+’/’+ls2+’/’+inls2): ininlist=os.listdir(dir0+’/’+ls2+’/’+inls2) ininlist.sort() print(ininlist) print(Image.open(dir0+’/’+ls2+’/’+inls2+’/’+ininlist[0],’r’).format) shutil.copy(dir0+’/’+ls2+’/’+inls2+’/’+ininlist[0],dir0+’/’+inls2+’.’+str(Image.open(dir0+’/’+ls2+’/’+inls2+’/’+ininlist[0],’r’).format).lower().replace(‘jpeg’,’jpg’)) if not os.path.isdir(dir0+’/’ + ls2 + ‘/’ + inls2): […]
. Read more