您好,登錄后才能下訂單哦!
這是現(xiàn)實中的一個例子,但是我不推薦使用MySQL分區(qū)用于生產(chǎn)
CREATE?TABLE?`t_log`?( ??`ID`?int(11)?NOT?NULL?AUTO_INCREMENT?COMMENT?'主鍵ID', ??`VERSON`?int(11)?NOT?NULL?DEFAULT?0?COMMENT?'?版本號', ??`ACTIONS`?varchar(100)?DEFAULT?NULL?COMMENT?'?操作記錄', ??`ADMINID`?int(11)?DEFAULT?1?COMMENT?'管理員ID', ??`IP`?varchar(20)?DEFAULT?'1'?COMMENT?'?登錄Ip', ??`CDATE`?datetime?NOT?NULL?COMMENT?'添加時間', ??`UDATE`?datetime?NOT?NULL?COMMENT?'修改時間', ??PRIMARY?KEY?(`ID`,`CDATE`), ??KEY?`ADMINID`?(`ADMINID`)?USING?BTREE )?ENGINE=InnoDB???DEFAULT?CHARSET=utf8?COMMENT='日志表' Time:?0.024s ALTER?TABLE?`blog`.`t_log`?PARTITION?BY?RANGE?(year(`CDATE`)) PARTITIONS?1 SUBPARTITION?BY?HASH?(to_days(`CDATE`)) SUBPARTITIONS?4 (PARTITION?`p0`?VALUES?LESS?THAN?(2020)?? (SUBPARTITION?`s200`??, SUBPARTITION?`s201`??, SUBPARTITION?`s202`??, SUBPARTITION?`s203`??)) Time:?0.057s alter?table?t_log ADD?PARTITION?(PARTITION?`p1`?VALUES?LESS?THAN?(2021)( SUBPARTITION?`s210`?ENGINE?=?InnoDB, ??SUBPARTITION?`s211`?ENGINE?=?InnoDB, ??SUBPARTITION?`s212`?ENGINE?=?InnoDB, ??SUBPARTITION?`s213`?ENGINE?=?InnoDB )) Time:?0.054s
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。