悠悠博客 (讨论区存档) — 技术永无止尽，未来事在人为

mysqldump 出来的表语句问题

[code]ObjId` bigint(20) unsigned DEFAULT '0',
`TradeToPlayerID` int(11) unsigned DEFAULT '0',
`TradeToPlayerName` varchar(24) DEFAULT NULL,
`StallSellToPlayerID` int(11) unsigned DEFAULT '0',
`StallSellToPlayerName` varchar(24) DEFAULT NULL,
KEY `ActionTime` (`ActionTime`),
KEY `PlayerAccount` (`PlayerAccount`),
KEY `TypeId` (`TypeId`),
KEY `ObjId` (`ObjId`),
KEY `PlayerId` (`PlayerId`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk /*!50100 PARTITION BY RANGE (MONTH(ActionTime)) (PARTITION p0 VALUES LESS THAN (1) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p1 VALUES LESS THAN (2) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p2 VALUES LESS THAN (3) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p3 VALUES LESS THAN (4) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p4 VALUES LESS THAN (5) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p5 VALUES LESS THAN (6) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p6 VALUES LESS THAN (7) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p7 VALUES LESS THAN (8) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p8 VALUES LESS THAN (9) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p9 VALUES LESS THAN (10) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p10 VALUES LESS THAN (11) DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM, PARTITION p11 VALUES LESS THAN MAXVALUE DATA DIRECTORY = '/export/mysql/var/gamelog/part_data' INDEX DIRECTORY = '/export/mysql/var/gamelog/part_index' ENGINE = MyISAM) */;
[/code]


分区的语句怎么都注释了 :wink: