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;
Posted by Jayakumar Official at 00:42 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: auto_increment, mysql

how to set autoincrement in mysql after creating table



mysql>
            Alter table table_name modify column_name datatype(length) AUTO_INCREMENT;
Posted by Jayakumar Official at 00:09 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: auto_increment, mysql
Newer Posts Home
Subscribe to: Posts (Atom)

About Me

Jayakumar Official
View my complete profile

Blog Archive

  • ▼  2015 (10)
    • ►  May (5)
    • ►  April (2)
    • ►  March (1)
    • ▼  February (2)
      • how to set default value for auto_increment in mysql
      • how to set autoincrement in mysql after creating t...
Awesome Inc. theme. Powered by Blogger.