msyql 分区

2016-10-25 19:34:29 catherine

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for dept -- ---------------------------- DROP TABLE IF EXISTS `dept`; CREATE TABLE `dept` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pname` varchar(5) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; ALTER TABLE dept PARTITION BY range(id) (partition p0 values less than (2), partition p1 values less than (4), partition p2 values less than (MAXVALUE)); select * from dept partition (p2); 就这样子。哈哈。

分类: web

标签:

微信号：腾讯云折扣返现

技术讨论QQ群： 863102326

作者: catherine

搜索

study ab amap apache apahe awk aws bat centos CFS chrome cmd cnpm composer consul crontab css curl cygwin devops di docker docker,docker-compose ethereum excel fiddler fluentd framework front-end git gitgui github glide go golang gorm grafana gzip ioc item2 iterm2 javascript jenkins jsonp kafka laradock laravel larval linux liunux log mac mac, wi-fi macos magento mariaDB minikube mongoDB msp mysql netbeans nginx nodejs nohup npm nsq oracle php php-fpm php7 phpstorm php扩展 Protobuf python redis scp server shell soap socket socket5 sql sre ssdb ssh ssl study sublime swift system td-agent uml v2ray vagrant vagrnat vim vpn vue vue.js webpack webrtc websocket webtatic windows windows7 word wps xdebug yarn yii2 yum zookeeper 世界国家互联网以太坊分类前端小程序打印机排序算法搞笑权限粤语缓存网络虚拟机视频设计模式项目管理