批量创建日期分表

  date=`date -d "+0 day $1" +%Y%m%d`
enddate=`date -d "+1 day $2" +%Y%m%d`

echo "------------------------------"
echo "date=$date"
echo "enddate=$enddate"
echo "------------------------------"


while [[ $date < $enddate ]]
do
echo $date
date=`date -d "+1 day $date" +%Y%m%d`
mysql -uroot -p'bbtree_db_!@#$%' -S /tmp/mysql_3306.sock -P 3306 -e " use attendance; CREATE TABLE __test_zhs_attendance_record_$date (
id int(11) NOT NULL AUTO_INCREMENT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

"
done

转载于:https://www.cnblogs.com/DBA-tomzhao/p/8601925.html