In mysql, how does one use data tables to store and increment multiple sequences ?? CREATETABLE 'sequence '('seq _ val' int (11) NOTNULLAUTO_INCREMENTCOMMENT sequence id, 'seq _ name' varchar (128) notnulldefacommcomment sequence name, PRIMARYKEY ('seq _ name ', 'seq _ val '),
In mysql, how does one use data tables to store and increment multiple sequences? ? Create table 'sequence '('seq _ val' int (11) not null AUTO_INCREMENT COMMENT 'sequence id', 'seq _ name' varchar (128) not null default ''comment' sequence name', primary key ('seq _ name', 'seq _ val '),
How to use data tables in mysql to store and increase multiple sequences
?
?
Create table 'sequence '('seq _ val' int (11) not null AUTO_INCREMENT COMMENT 'sequence id', 'seq _ name' varchar (128) not null default ''comment' sequence name', 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);}
?