New answers tagged auto-increment
Two things I learned here. Insert a record, and edit the last insert id. Alter table auto-increment, which will take sometime. It's better to just deal with the problem using #1
Autoincrement values can only be numeric (integer and floats types if I remember correctly). If you want to store S1, ...., S1000, just store an integer, and return the extra S on select or on client side: create table tbl(ID bigint not null primary key auto_increment,name varchar(100)) auto_increment=1; insert into tbl (name) values ('a'); ... select ...
Top 50 recent answers are included