mysql下，如何利用数据表来实现多个序列的存储及递增

 

 

CREATE TABLE `sequence` (
  `seq_val` int(11) NOT NULL AUTO_INCREMENT COMMENT '序列id',
  `seq_name` varchar(128) NOT NULL DEFAULT '' COMMENT '序列名称',
  PRIMARY KEY (`seq_name`,`seq_val`),
  UNIQUE KEY `idx_seqname` (`seq_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

 

public interfaceSequenceDao {
      @Insert("replace into wm_sequence(seq_name) values(#{seq_name})")
      @Options(useGeneratedKeys = true,keyProperty="seq_val")
      public void getSeqidByName(WmSequence seq);
}