MySQL Primary Key: How to Specify

1 year ago
Liam
1 minute

In MySQL, you can specify a table’s primary key using the following method:

  1. Specify the primary key when creating the table.
CREATE TABLE table_name (
    id INT PRIMARY KEY,
    column1 datatype,
    column2 datatype,
    ...
);
  1. Add a primary key constraint to an existing table.
ALTER TABLE table_name
ADD PRIMARY KEY (id);

In the example above, the “id” column in the table is designated as the primary key. You can choose the appropriate column as the primary key based on the actual situation.

bannerAds