Use the following SQL statement, put more than one column name in the brackets if you want more than one column as the primary key.

ALTER IGNORE TABLE ADD PRIMARY KEY ()

How to add a primary key index to a table and ignore and remove duplicates

Leave a Reply

Your e-mail address will not be published. Required fields are marked *

seventy − = sixty seven