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

normality factor and selection of indicator in acid base titration

Image
  Sometimes, it becomes difficult to calculate the exact weight of the solute. Under this condition, the concentration of prepared solution becomes different from proposed solution and the term normality factor must be introduced. Mathematically,  Normality factor= (Weight taken) / (weight to be taken) Normality factor indicates by how many times the concentration of prepared solution is different from proposed solution.   For eg: If we have to prepare 500ml decinormal oxalic acid solution, the weight we have to take is 3.15gm. In lab due to certain difficulties, if weight is taken as 3.10 gm, then normality factor will be equivalent to =3.1/3.15 = 0.98 and concentration is expressed as N/10 (f=0.98) It indicates that the concentration of prepared solution is 0.98 times than that of proposed concentration. Selection of indicator in acid base titration:       In acid base titration the completion of reaction is usually indicated by using the t...
Read more

Introduction to computer

Background:   Computer is the most powerful tool men have ever developed. It is changing our day to day life style. The need of computer has been felt in homes, schools, colleges, offices, banks, hospitals, industries, airlines, military, and so on. Computers have the capacity to store vast quantities of information.
Read more

science note ionic equilibrium

Image
Ionic equilibrium     When certain electrolyte is dissolve in watter, it split into two type of ions, one carry positive charge and another carrying negative charge. The positive charge carrying species are called cation and negative charge carrying species are called anion.       Under this condition, equilibriup exist between undissociated ions. This type of equilibrium exist between undissociated electrolyte molecule and dissociated ion is called ionic equilibrium.      As the chemical equilibrium, ionic equilibrium is dynamic in nature i,e even in equilibrium condition, the reaction is going on.     But the concentration of specific involved will not change with time because in equilibrium condition both reaction proceed with same rate.      Let  us suppose, eletrolyte AB which dissociates as follows.    Here, forward reaction is ionization reaction and backward reaction is association...
Read more