How do I add an ID using PhpMyAdmin?

Answer 1

Two Methods can be used they are below:

Auto Increment1. Add a field as the first field (Under your fields, and Print View should be buttons and a Radio should say 'At Beginning of Table', check it then hit go.

1b. If you are in the add table screen use the top row for this.

2. Call it id or whatever you want provided you'll know it's the primary key

3. The Type (in the dropdown) is either int or bigint (if you want a lot of rows choose BigInt with 255 length)

3b. The Length is how many number's (in the case of Integers) e.g. 6 would mean 999999 is the maximum and 7 is 9999999)

4. In some version this will be a dropdown in some newer versions it's a tick box however find AUTO_INCREMENT and ensure it is ticked / selected

5. Either finish your table or hit save.

Something's to keep in mind:

1. Only one AUTO_INCREMENT field per table

2. The AUTO_INCREMENT field is the primary key, and in PhpMyAdmin this is often auto added as the Primary key.

Second MethodThis method is more manual and requires adding code when Inserting.

1. Add a field / make this the first field

2. Call it id or something that you'll know is the id

3. Make it an Int or BigInt

4. Read step 3a (of method 1) if you don't understand length with Integers

5. Save / Complete table

A. Then in php perform a MySql count (this method is basic so php isn't the only language this can be done in.

B. Add one to the Integer variable you saved the count in

C. In your insert make the Added count Variable your Insert for ID

Keep in mind way two will come in to issues if your site is used a lot or if the insert is on every page, for example logging people's habits.