Where to use Primary Key in mySQL?

[arronmattwills]

Primary is a single unique value which is used to identify in database search results, so that we can simple get our unique value.
Once we write this primary key in mySQL tables then we can write our php code in website.
Every single table in database should contains a primary key.
Primary key is a restriction (condition, limitation or a constraint).

 

[hoangvu]

According to me, Primary Key in mySQL is very important to identify a field as unique for its value, I used to use it for ID field in my mySQL tables.

 

[arronmattwills]

arronmattwills

Yes, i agree with you, we have to use primary key in mySQL tables only.

 

[AlexBell]

Primary key in that code is create ID column as primary key column. So you can not insert same value which is already exist in that table. SQL just check value when data is inserted into table, if the value is inserted into a primary key column is already exist then SQL cancel insert operation and reject all values.