批量创建100张表

#在工作中，经常会有以时间或者数字命名，创建n张表的需求。#下面给出4种常用的批量创建100张表的小脚本。#结果mysql> show tables;+-----------------+| Tables_in_tsdb  |+-----------------+| Total_Winner_01 || Total_Winner_02 || Total_Winner_03 || Total_Winner_04 || Total_Winner_05 || Total_Winner_06 || Total_Winner_07 || Total_Winner_08 || Total_Winner_09 || Total_Winner_10 || Total_Winner_11 || Total_Winner_12 || Total_Winner_13 || Total_Winner_14 || Total_Winner_15 |+-----------------+15 rows in set (0.00 sec)#第一种：##create 100 tables#!/bin/sh#db_name='USE RenmaiInfluenceDB'for i in {0 99};do     len=`expr length $i`    if [ $len -eq 2 ];then    num=$ielse    num="0${i}"fi    echo '''CREATE TABLE `Total_Winner_'''$num'''` (  `Id` INT (10),  `UserId` INT (10),  PRIMARY KEY (`Id`)) ENGINE = INNODB DEFAULT CHARSET = utf8 ;    '''echo done========================================================================================================#第二种：#!/bin/sh#creat tablesfor i in `seq 1 15`do    var=`printf "d\n" $i`       echo '''CREATE TABLE `Total_Winner_'''$var'''` (  `Id` INT (10),  `UserId` INT (10),  PRIMARY KEY (`Id`)) ENGINE = INNODB DEFAULT CHARSET = utf8 ;'''       echodone============================================================================#第三种：#!/bin/sh # 需要将 SQL 中的" ` " 符号删除for i in `seq 0 1 99`do    STEP=`printf d ${i}`    create_tab_sql="CREATE TABLE Total_Winner_${STEP} (  Id INT (10),  UserId INT (10),  PRIMARY KEY (Id)) ENGINE = INNODB DEFAULT CHARSET = utf8 ;"    echo -e ${create_tab_sql}        echodone===================================================================================#第四种：Python脚本#!/usr/bin/pythonimport stringfor i in range(7,13):    sql = "CREATE TABLE `Content_2015d` LIKE `Content_201503`;" % i    print(sql)for i in range(15,20):    sql = "CREATE TABLE `Content_2016d` LIKE `Content_201503`;" % i    print(sql)========================================