tags:

views:

36

answers:

1

I know in an actual query, you can use auto_increment=1 but how is this set with phpMyAdmin?

Is it even possible?

+1  A: 

Here is an excerpt on how to set a column to be auto incremented using phpMyAdmin:

In the latest phpMyAdmin versions there is a new A_I Checkbox. Mark this option as enabled when creating or editing your primary key table column and that numeric field will automatically increment its value each time a new record is inserted.

And, to set the initial count to a specific value:

Finally, if you want to change the current Auto Increment Value (i.e.: to make your auto increment field start from a specific numeric value) just select the phpMyAdmin Operations tab, type in the AUTO_INCREMENT field the new starting value of your auto incrementing field, and you are ready to go.

Taken from MySQL set auto_increment in phpMyAdmin

Anthony Forloney
Thanks. I couldn't find this anywhere.
George Edison
No problem, anytime :)
Anthony Forloney