programmingcollections

Showing posts with label auto_increment. Show all posts
Showing posts with label auto_increment. Show all posts

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
Home
Subscribe to: Posts (Atom)

About Me

Jayakumar Official
View my complete profile

Blog Archive

  • ▼  2015 (10)
    • ▼  May (5)
      • Deprecated: Function split() is deprecated
      • how to get radio button value in jquery?
      • Click HTML button to call PHP function
      • Upgrade Oracle Java 7 to Java 8 for Ubuntu
      • how to make or remove underline in css/html
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
Awesome Inc. theme. Powered by Blogger.