mysql show table partitions

Solutions on MaxInterview for mysql show table partitions by the best coders in the world

showing results for - "mysql show table partitions"
Valeria
21 Feb 2017
1Copied mysql> SHOW CREATE TABLE trb3\G
2*************************** 1. row ***************************
3       Table: trb3
4Create Table: CREATE TABLE `trb3` (
5  `id` int(11) default NULL,
6  `name` varchar(50) default NULL,
7  `purchased` date default NULL
8) ENGINE=MyISAM DEFAULT CHARSET=latin1
9PARTITION BY RANGE (YEAR(purchased)) (
10  PARTITION p0 VALUES LESS THAN (1990) ENGINE = MyISAM,
11  PARTITION p1 VALUES LESS THAN (1995) ENGINE = MyISAM,
12  PARTITION p2 VALUES LESS THAN (2000) ENGINE = MyISAM,
13  PARTITION p3 VALUES LESS THAN (2005) ENGINE = MyISAM
14)
151 row in set (0.00 sec)