下面是编程之家 jb51.cc 通过网络收集整理的代码片段。

编程之家小编现在分享给大家，也给大家做个参考。

#!/bin/bash
user=""
password=""
database=""
table=""
rows=$(MysqL -u$user -p$password $database -e "select DISTINCT EXTRACT(YEAR_MONTH from (ActionTime)) as 'month' from $table;")
#echo $rows
table_name=''
for tag in ${rows[@]}
do
  #echo "$tag"
  if [ $tag = "month" ];then
   continue
  fi
  table_name="$table_name""$table""_""$tag"" "; 
done
echo "${table_name}"


for table_i in ${table_name[@]}
do
  MysqL -u$user -p$password $database << EOF 2>/dev/null
  CREATE TABLE $table_i(
   表结构
 ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

EOF
[ $? -eq 0 ] && echo "Created table $table_i" || echo "Table $table_i  already exist" 
  temp=${table_i##*_}
  startdate=${temp:0:4}'-'${temp:4}'-01'
  enddate=${temp:0:4}'-'${temp:4}'-31'
  echo "startdate=${startdate},enddate=${enddate}" 
  
  total_rows=$(MysqL -u$user -p$password $database -N -e "select count(*) from $table where ActionTime BETWEEN '$startdate' and '$enddate';")
  echo '总行数='"${total_rows}"
  page_size=1000
  page_num=0
  mod=`expr $total_rows % $page_size`
  echo '取摸='"${mod}"
  if [ $mod -gt 1 ];then
    page_num=`expr $total_rows / $page_size + 1`
  else
    page_num=`expr $total_rows / $page_size`
  fi
  echo '总页数='"${page_num}"

add_size=0
for((i=0;i<$page_num;i++))
do
  MysqL -r$root -p$password $database << EOF 2>/dev/null
  INSERT INTO $table_i SELECT * FROM PageView WHERE $table.ActionTime BETWEEN '$startdate' AND '$enddate' LIMIT $add_size,$page_size;
EOF
add_size=`expr $add_size + $page_size`
done
done
echo "sharding $table successful!"

以上是编程之家(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。