Displaying 1 result from an estimated 1 matches for "auto_increment_offset".
2006 Aug 13
0
Custom id field auto_increment increment and offset?
Hi all,
in mysql, you can set the following environment variables:
set @@auto_increment_offset = 4;
set @@auto_increment_increment =10;
such that:
create table people (id int auto_increment primary key, name char(100));
insert into people set name=''Giuseppe'';
insert into people set name=''Laura'';
select * from people;
+----+----------+
| id | name...