Mysqlでパーティショニングをしようとするとエラーが出てしまいます、どうすれば解決しますか?
Syntax error: LIST PARTITIONING requires definition of VALUES IN for each partition
mysql
1CREATE TABLE `part` ( 2 `id` int(11) unsigned NOT NULL AUTO_INCREMENT, 3 `zip` varchar(255) DEFAULT NULL, 4 `pref` varchar(255) DEFAULT NULL, 5 `ward` varchar(255) DEFAULT NULL, 6 `area` varchar(255) DEFAULT NULL, 7 `pref_kana` varchar(255) DEFAULT NULL, 8 `ward_kana` varchar(255) DEFAULT NULL, 9 `area_kana` varchar(255) DEFAULT NULL, 10 PRIMARY KEY (`id`) 11) ENGINE=InnoDB DEFAULT CHARSET=utf8 12 13ALTER TABLE `part` PARTITION BY LIST COLUMNS(pref_kana) ( 14 PARTITION AICHI VALUES IN ('AICHI KEN'), 15 PARTITION AKITA VALUES IN ('AKITA KEN'), 16 PARTITION AOMORI VALUES IN ('AOMORI KEN'), 17 PARTITION CHIBA VALUES IN ('CHIBA KEN'), 18 PARTITION EHIME VALUES IN ('EHIME KEN'), 19 PARTITION FUKUI VALUES IN ('FUKUI KEN'), 20 PARTITION FUKUOKA VALUES IN ('FUKUOKA KEN'), 21 PARTITION FUKUSHIMA VALUES IN ('FUKUSHIMA KEN'), 22 PARTITION GIFU VALUES IN ('GIFU KEN'), 23 PARTITION GUMMA VALUES IN ('GUMMA KEN'), 24 PARTITION HIROSHIMA VALUES IN ('HIROSHIMA KEN'), 25 PARTITION HOKKAIDO VALUES IN ('HOKKAIDO'), 26 PARTITION HYOGO VALUES IN ('HYOGO KEN'), 27 PARTITION IBARAKI VALUES IN ('IBARAKI KEN'), 28 PARTITION ISHIKAWA VALUES IN ('ISHIKAWA KEN'), 29 PARTITION IWATE VALUES IN ('IWATE KEN'), 30 PARTITION KAGAWA VALUES IN ('KAGAWA KEN'), 31 PARTITION KAGOSHIMA VALUES IN ('KAGOSHIMA KEN'), 32 PARTITION KANAGAWA VALUES IN ('KANAGAWA KEN'), 33 PARTITION KOCHI VALUES IN ('KOCHI KEN'), 34 PARTITION KUMAMOTO VALUES IN ('KUMAMOTO KEN'), 35 PARTITION KYOTO FU VALUES IN ('KYOTO FU '), 36 PARTITION MIE VALUES IN ('MIE KEN'), 37 PARTITION MIYAGI VALUES IN ('MIYAGI KEN'), 38 PARTITION MIYAZAKI VALUES IN ('MIYAZAKI KEN'), 39 PARTITION NAGANO VALUES IN ('NAGANO KEN'), 40 PARTITION NAGASAKI VALUES IN ('NAGASAKI KEN'), 41 PARTITION NARA VALUES IN ('NARA KEN'), 42 PARTITION NIIGATA VALUES IN ('NIIGATA KEN'), 43 PARTITION OITA VALUES IN ('OITA KEN'), 44 PARTITION OKAYAMA VALUES IN ('OKAYAMA KEN'), 45 PARTITION OKINAWA VALUES IN ('OKINAWA KEN'), 46 PARTITION OSAKA FU VALUES IN ('OSAKA FU '), 47 PARTITION SAGA VALUES IN ('SAGA KEN'), 48 PARTITION SAITAMA VALUES IN ('SAITAMA KEN'), 49 PARTITION SHIGA VALUES IN ('SHIGA KEN'), 50 PARTITION SHIMANE VALUES IN ('SHIMANE KEN'), 51 PARTITION SHIZUOKA VALUES IN ('SHIZUOKA KEN'), 52 PARTITION TOCHIGI VALUES IN ('TOCHIGI KEN'), 53 PARTITION TOKUSHIMA VALUES IN ('TOKUSHIMA KEN'), 54 PARTITION TOKYO TO VALUES IN ('TOKYO TO '), 55 PARTITION TOTTORI VALUES IN ('TOTTORI KEN'), 56 PARTITION TOYAMA VALUES IN ('TOYAMA KEN'), 57 PARTITION WAKAYAMA VALUES IN ('WAKAYAMA KEN'), 58 PARTITION YAMAGATA VALUES IN ('YAMAGATA KEN'), 59 PARTITION YAMAGUCHI VALUES IN ('YAMAGUCHI KEN'), 60 PARTITION YAMANASHI VALUES IN ('YAMANASHI KEN') 61);
回答1件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2017/01/13 08:43
2017/01/13 08:48 編集
2017/01/15 07:03