how do i change my primary key from a pre-existing column to a new column i just created?
ALTER TABLE table_name DROP PRIMARY KEY, ADD PRIMARY KEY (new_column_name)
table_name
reg kevin
