MySQL 파티션
From IT Wiki
Revision as of 01:40, 26 February 2023 by Dbeaver (talk | contribs) (새 문서: == 파티션 조회 == <syntaxhighlight lang="sql"> select * from information_schema.partitions where table_name = '테이블명' </syntaxhighlight> == 파티션 추가 == <syntaxhighlight lang="sql"> alter table '테이블명' add partition ( PARTITION `파티션명` VALUES LESS THAN (파티션 값) } </syntaxhighlight> == 파티션 삭제(drop) == <syntaxhighlight lang="sql"> ALTER TABLE `테이블명` DROP PARTITION '파티션명' </syntaxhighlight> == 파티션 비...)
파티션 조회[edit | edit source]
select
*
from information_schema.partitions
where table_name = '테이블명'
파티션 추가[edit | edit source]
alter table '테이블명' add partition
(
PARTITION `파티션명` VALUES LESS THAN (파티션 값)
}
파티션 삭제(drop)[edit | edit source]
ALTER TABLE `테이블명` DROP PARTITION '파티션명'
