AUTO INCREMENT IN SQL: How to Set Your Primary Key To Auto Increment

I often used an auto increment primary key in creating my table due to unavailable candidate for a primary key. With the use of the use of the auto increment property, you will avoid duplicate entries for your primary key.

So here is the easy way on how to do it.

First, you add new table and you write the table name, column name, data type, length. For your primary key, you must set the data type into integer since you cannot increment other data types.

Then, under the index column, select PRIMARY from the drop down menu.

Third, you need to check the checkbox under the A_I column. A_I stands for auto increment.

Click the save button and that's it! You're done! Hope this helps!

AUTO INCREMENT IN SQL: How to Set Your Primary Key To Auto Increment

AUTO INCREMENT IN SQL: How to Set Your Primary Key To Auto Increment 2016-01-29T06:19:00-08:00 Rating: 4.5 Diposkan Oleh: Emoblazz