分享db 分区分表的shell
16库与表 输出0到f
##输出0到f
#/bin/bash
for table in {0..15};do
printf "%x
" $table
done
结果:
0
1
2
3
..
f
#/bin/bash
#输出00-ff 256表
for table in {0..255};do
printf "%02x
" $table
done
结果:
00
01
02
03
04
05
06
07
08
09
0a
0b
0c
..
fe
ff
sql导出csv文件分享
如4.sh输出sql语句
bash 4.sh |mysql -hhost -uroot -ppasswd -N |sed -i 's/ ab/,/g'