56,940
社区成员




ALTER TABLE files PARTITION BY RANGE
(UNIX_TIMESTAMP(created_at))
(PARTITION {$pname} VALUES LESS THAN ({$less_than_time}))
selct CONVERT(CONCAT(left(unix_timestamp(now()),3), left('9777215210102229301',7)),SIGNED)
ALTER TABLE files PARTITION BY
RANGE(CONVERT(CONCAT(left(unix_timestamp(now()),3), left(id,7)),SIGNED))
(PARTITION {$pname} VALUES LESS THAN ({$less_than_time}))
ALTER TABLE files PARTITION BY
RANGE(
UNIX_TIMESTAMP(FROM_UNIXTIME(
CONCAT(left(unix_timestamp(now()),3), left('9777215210102229301',7)))
)
)
(PARTITION '2017' VALUES LESS THAN 150981119)