{"id":1843,"date":"2015-12-03T04:47:46","date_gmt":"2015-12-03T04:47:46","guid":{"rendered":"http:\/\/www.msinterdev.org\/wp\/2015\/12\/03\/mysql-partition-creation\/"},"modified":"2015-12-03T04:47:46","modified_gmt":"2015-12-03T04:47:46","slug":"mysql-partition-creation","status":"publish","type":"post","link":"http:\/\/www.msinterdev.org\/wp\/2015\/12\/03\/mysql-partition-creation\/","title":{"rendered":"MySql partition Creation"},"content":{"rendered":"

For Example><\/p>\n

ALTER TABLE TB_SMS_HISTORY
PARTITION BY RANGE (TO_DAYS(REG_DATE))
(
   
PARTITION p001 VALUES LESS THAN (TO_DAYS(‘2015-12-01’)),
PARTITION p002 VALUES LESS THAN (TO_DAYS(‘2016-01-01’)),
PARTITION p003 VALUES LESS THAN (TO_DAYS(‘2016-02-01’)),
….
..
};<\/p>\n

<\/p>\n

\n
<\/a><\/div>\n<\/div>\n
ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));<\/pre>\n","protected":false},"excerpt":{"rendered":"
For Example> ALTER TABLE TB_SMS_HISTORYPARTITION BY RANGE (TO_DAYS(REG_DATE))(    PARTITION p001 VALUES LESS THAN (TO_DAYS(‘2015-12-01’)),PARTITION p002 VALUES LESS THAN (TO_DAYS(‘2016-01-01’)),PARTITION p003 VALUES LESS THAN (TO_DAYS(‘2016-02-01’)),……}; ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN (2002));<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1395,3494],"class_list":["post-1843","post","type-post","status-publish","format-standard","hentry","category-about-knowledge-db_sql","tag-mysql","tag-partition"],"_links":{"self":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/posts\/1843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/comments?post=1843"}],"version-history":[{"count":0,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/posts\/1843\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/media?parent=1843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/categories?post=1843"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/tags?post=1843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}