通常
CREATE TABLE IF NOT EXISTS `test_01` (
id INT NOT NULL,
str_200_len VARCHAR(200) NOT NULL,
created_date DATE NOT NULL,
updated_date TIMESTAMP NOT NULL,
PRIMARY KEY(id)
) COMMENT 'table comment';
DROP TABLE IF EXISTS `test_01`;
ビックデータ(パテーション)
CREATE TABLE IF NOT EXISTS `test_01` (
id INT NOT NULL,
str_200_len VARCHAR(200) NOT NULL,
created_date DATE NOT NULL,
updated_date TIMESTAMP NOT NULL,
PRIMARY KEY(id)
) COMMENT 'table comment' PARTITION BY RANGE( id ) (
PARTITION p0 VALUES LESS THAN (1000),
PARTITION p1 VALUES LESS THAN (2000)
);
DROP TABLE IF EXISTS `test_01`;