programmingcollections
Friday, 27 February 2015
how to set default value for auto_increment in mysql
To reset default value for auto increment fields
mysql>
alter table table_name modify column_name datatype(size) not null auto_increment first;
how to set autoincrement in mysql after creating table
mysql>
Alter table table_name modify column_name datatype(length) AUTO_INCREMENT;
Newer Posts
Home
Subscribe to:
Posts (Atom)