编程

使用Linux Shell脚本操作mysql 

1
mysql -hbigdata.hohode.com   -P3305    -uhohode  -p123456  -e"select * from scene where statistics_date = '2018-08-31' "

查询当天，前一天的日期

1
select CURDATE(),date_sub(curdate(),interval 1 day) from job_qrtz_trigger_log

linux shell for 循环遍历字符串

1
2
3
4
for t in "appnsformation" "a" "b"
do
	echo  $t
done

参考 http://www.w3school.com.cn/sql/func_curdate.asp