go语言写分表脚本

CREATE TABLE `outbound_sku_tab_00000000` (
 `id` bigint(20) unsigned NOT NULL COMMENT '雪花算法',
  `outbound_order_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku_id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku_num_picked` int(7) NOT NULL,
  `sku_num_total` int(7) NOT NULL,
  `ctime` int(11) unsigned NOT NULL,
  `mtime` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_outbound_order_id_sku_id` (`outbound_order_id`,`sku_id`), 
  KEY `id x_sku_id` (`sku_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

如上表要分150份

package main

import (
	"fmt"
	"os"
)

func main() {
	str := "CREATE TABLE `outbound_sku_tab_%08d` LIKE `outbound_sku_tab_00000000`;\n"
	f, _ := os.OpenFile("sql_create/sql.txt", os.O_RDWR|os.O_TRUNC|os.O_CREATE, 0766)
	os.Stdout = f
	for i := 1; i < 150 ; i++ {
		fmt.Printf(str, i)
	}
}

结果

CREATE TABLE `outbound_sku_tab_00000001` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000002` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000003` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000004` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000005` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000006` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000007` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000008` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000009` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000010` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000011` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000012` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000013` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000014` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000015` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000016` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000017` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000018` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000019` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000020` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000021` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000022` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000023` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000024` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000025` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000026` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000027` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000028` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000029` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000030` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000031` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000032` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000033` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000034` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000035` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000036` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000037` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000038` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000039` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000040` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000041` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000042` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000043` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000044` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000045` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000046` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000047` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000048` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000049` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000050` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000051` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000052` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000053` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000054` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000055` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000056` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000057` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000058` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000059` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000060` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000061` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000062` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000063` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000064` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000065` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000066` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000067` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000068` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000069` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000070` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000071` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000072` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000073` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000074` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000075` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000076` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000077` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000078` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000079` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000080` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000081` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000082` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000083` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000084` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000085` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000086` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000087` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000088` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000089` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000090` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000091` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000092` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000093` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000094` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000095` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000096` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000097` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000098` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000099` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000100` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000101` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000102` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000103` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000104` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000105` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000106` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000107` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000108` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000109` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000110` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000111` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000112` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000113` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000114` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000115` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000116` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000117` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000118` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000119` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000120` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000121` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000122` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000123` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000124` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000125` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000126` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000127` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000128` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000129` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000130` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000131` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000132` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000133` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000134` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000135` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000136` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000137` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000138` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000139` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000140` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000141` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000142` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000143` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000144` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000145` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000146` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000147` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000148` LIKE `outbound_sku_tab_00000000`;
CREATE TABLE `outbound_sku_tab_00000149` LIKE `outbound_sku_tab_00000000`;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值