MySQL adds a primary key to an existing table pk_id in the first row

1, for some already exist the joint primary key, first delete.

Alter Table Drop Primary key;

2. Then add the ID to the first row of the table with the name pk_id

Alter Table Add bigint (notnullprimarykey first;

3. If you want to add a self-increment ID to all tables in the database, the name is pk_id

SELECT
CONCAT (' ALTER TABLE ', TABLE_NAME, ' Add pk_id bigint () NOT NULL auto_increment primary key first; ')
From Information_schema.tables t
WHERE t.table_name like ' prefix% ';

Prefixes are prefixes that represent the names of data tables, such as busi_table, where the prefix is busi, and all prefixes are found to be busi.

MySQL adds a primary key to an existing table pk_id in the first row