data create primery key code example

Example 1: MySQL Primary Key

Typically, you define the primary key for a table in the CREATE TABLE statement.

If the primary key has one column, you can use the PRIMARY KEY constraint as a column constraint:

CREATE TABLE table_name(
    primary_key_column datatype PRIMARY KEY,
    ...
);

Example 2: create id to primary using query

ALTER TABLE lead_offer_notes ADD PRIMARY KEY (id);

Tags:

Sql Example

Related