How to start auto increment value from certain value in mysql or Change default value for auto increment field mysql table

 

Q> How to start auto increment value from certain value in mysql ??
                                     or
Change default value for auto increment field mysql table

Solution 1:  Execute query:   ALTER TABLE TABLE_NAME AUTO_INCREMENT = 2000;
  

Solution 2: From Picture  

  • Go to localhost/phpmyadmin

     


  • Select your database and table. At top right: click on "Operations". 



  • Then you can see AUTO_INCREMENT field. Just change it. Default is 1.




 

Tag: auto increment, value, change default, new start, point mysql, phpmyadmin,

Comments

Post a Comment

Popular posts from this blog

Puppetting on string | Let us C solution with details description and tutorials | yashwant kanetkar

Image
  Chapter: Puppetting on string | Let us C solution with details description and tutorials |  yashwant kanetkar S.N Chapter S.N Chapter 1 Decision Control Structure 5 Arrays 2 The Loop Control Structure 6 Puppetting On Strings  3 The Case Control Structure 7 Structures 4 Function and Pointer 8 Input/Output in C [D] Attempt the following: (a) Which is more appropriate for reading in a multi-word string? gets( ) printf( ) scanf( ) puts( ) Show Solutions     Hide Solutions Chapter:  Puppetting On Strings /*  [D] Attempt the following: (a) Which is more appropriate for reading in a multi-word string? gets( ) printf( ) scanf( ) puts( )  */ #include <stdio.h>  //header file #include <conio.h>  //header file int main()  //main function {      // Answer: Option A gets()   char string[40];    printf("Enter a string:");    gets(string);    printf("The string input was: %s\n", string); getch(); return 0;  // ret
Read more

If cost price and selling price of an item is input through the keyboard, write a program to determine whether the seller has made profit or incurred loss. Also determine how much profit he made or loss he incurred

  Chapter: Decision Control Structure /* C (a)If cost price and selling price of an item is input through  the keyboard, write a program to determine whether the seller  has made profit or incurred loss. Also determine how much  profit he made or loss he incurred.*/ #include <stdio.h>  //header file #include <conio.h>   //header file int main()          //main function.. starting of c code {     int cp,sp,check;     printf("enter cost price: ");     scanf("%d",&cp);     printf("\nenter selling price:");     scanf("%d",&sp);     check=sp-cp;     if(check>0)     {                printf("\nSeller have profit");                printf("\nHe got %d profit",check);          }     else if(check<0)     {          check=cp-sp;          printf("\nSeller have Loss");          printf("\nHe got %d loss",check);      }      else      printf("You have neither loss nor profit");          
Read more