MySQL Primary Key

Submitted by arilio666 on Thu, 04/21/2022 - 11:05

The primary key constraint is used to identify a record or row uniquely in a database, and it does not allow NULL values and accepts unique ones.

MySQL Create Table Primary Key

CREATE TABLE office (
emp_ID int ,
emp_fName varchar(255) NOT NULL,
emp_lName varchar(255) NOT NULL,
Age int
CHECK(Age <= 50),
PRIMARY KEY (emp_ID)
);