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!
Home /
Auto Increment /
MySQL /
AUTO INCREMENT IN SQL: How to Set Your Primary Key To Auto Increment
Friday, January 29, 2016
AUTO INCREMENT IN SQL: How to Set Your Primary Key To Auto Increment
Related Articles :
PHP ARRAYS: How To Save Multiple Arrays in DatabaseI have encountered saving a single array from a checkbox into the database. But in this example, I have here several input controls th ...
PHP MYSQL: Search Multiple Columns Using LikeI had encountered searching multiple columns using a single input control, a textbox. That is searching from a last name and first nam ...
SQL QUERY WILDCARD: Display Values Based on a String Pattern Using SQL Query Like and SQL Query WildcardWe often search to find a certain data easily in our database. Such as searching for a friends name in facebook. And perhaps, searchin ...
SQL JOIN: Display Records With or Without Match on The Other TableThere will be cases where you want to join two (2) table and display records that has match or even without match on the other table.T ...
PHP INSERT INTO: Add New Record Into A DatabaseData is essential in an organization. So storing it in a database helps an organization to easily store it so they can retrieve it in ...
Subscribe to:
Post Comments (Atom)
Casino Slot Machines Near You - MapyRO
ReplyDeleteCasino Slot Machines Near Me - Find Casino Slot Machines Near 강원도 출장샵 You and Search for Casinos Near You 파주 출장안마 in the 군포 출장샵 This map shows the closest casinos to 동해 출장마사지 your city, in real time, 경주 출장안마