Re: feature proposal: auto increment prefix

2002-09-12 Thread Paul DuBois
At 0:47 -0500 9/13/02, [EMAIL PROTECTED] wrote: > > > 2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory >> > PREFIX. MySQL would then assign values that start with the prefix, >> > followed by a sequential number. >> >> This works already for MyISAM and BDB tables. From the man

Re: feature proposal: auto increment prefix

2002-09-12 Thread dvorakv
> > 2) Make a CHAR (or VARCHAR) AUTO_INCREMENT column with mandatory > > PREFIX. MySQL would then assign values that start with the prefix, > > followed by a sequential number. > > This works already for MyISAM and BDB tables. From the manual: > > CREATE TABLE animals ( > grp ENUM('f

feature proposal: auto increment prefix

2002-09-12 Thread dvorakv
Hello list! I would like to propose a feature for MySQL that would solve the multiple master replication problem. Unless I miss some important information, there is currently a limitation to the use of master-master replication which concerns AUTO_INCREMENT columns (which are usually used as PRI