分库分表的垂直切分与水平切分看这篇就够了！
复制//拆分前
CREATETABLE `product` (
`id` int(11) unsigned NOTNULL AUTO_INCREMENT,
`title` varchar(524) DEFAULTNULL COMMENT 视频标题,
`cover_img` varchar(524) DEFAULTNULL COMMENT 封面图,
`price` int(11) DEFAULTNULL COMMENT 价格,分,
`total` int(10) DEFAULT0 COMMENT 总库存,
`left_num` int(10) DEFAULT0 COMMENT 剩余,
`learn_base` text COMMENT 课前须知，学习基础,
`learn_result` text COMMENT 达到水平,
`summary` varchar(1026) DEFAULTNULL COMMENT 概述,
`detail` text COMMENT 视频商品详情,
PRIMARYKEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
//拆分后
CREATETABLE `product` (
`id` int(11) unsigned NOTNULL AUTO_INCREMENT,
`title` varchar(524) DEFAULTNULL COMMENT 视频标题,
`cover_img` varchar(524) DEFAULTNULL COMMENT 封面图,
`price` int(11) DEFAULTNULL COMMENT 价格,分,
`total` int(10) DEFAULT0 COMMENT 总库存,
`left_num` int(10) DEFAULT0 COMMENT 剩余,
PRIMARYKEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
CREATETABLE `product_detail` (
`id` int(11) unsigned NOTNULL AUTO_INCREMENT,
`product_id` int(11) DEFAULTNULL COMMENT 产品主键,
`learn_base` text COMMENT 课前须知，学习基础,
`learn_result` text COMMENT 达到水平,
`summary` varchar(1026) DEFAULTNULL COMMENT 概述,
`detail` text COMMENT 视频商品详情,
PRIMARYKEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.
THE END
