Add A Primary Key To A Table In MYSQL

Run the following code to amend an existing column into a Primary Key

 ALTER TABLE `wp_posts`
  ADD PRIMARY KEY (`ID`),
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
Disclaimer: The code on this website is provided "as is" and comes with no warranty. The author of this website does not accept any responsibility for issues arising from the use of code on this website. Before making any significant changes, ensure you take a backup of all files and do not work directly on a live/production website without thoughly testing your changes first.

Leave a Reply

Your email address will not be published. Required fields are marked *