If you want to remove the auto-increment and the primary key from the ID column in a single SQL statement, this should do. ALTER TABLE wp_posts CHANGE ID ID int(11) UNSIGNED NOT NULL; -- Removes auto-inrement from ID DROP INDEX `PRIMARY` ON wp_posts; -- Removes index PRIMARY from provided table ALTER TABLE wp_posts ADD primary key (ID); -- Add index again ALTER TABLE wp_posts DROP PRIMARY KEY, CHANGE ID ID int(11) UNSIGNED NOT NULL; ALTER TABLE wp_posts ADD primary key (ID);
Engineering
How to reindex tables with MySQL
[code lang=”sql”] ALTER TABLE wp_posts CHANGE ID ID int(11) UNSIGNED NOT NULL; — Removes auto-inrement from ID DROP INDEX `PRIMARY` ON wp_pos
· 5 min read
Related posts
Engineering
Lamudi.pk Real Estate Growth
There are several online real estate portals running in Pakistan, a couple of them have captured the market and leading the industry. In such a scenario it’s ha
Engineering
My 3 Days Trip to Swat, Malam Jabba and Kalam
Pakistan is a land of natural beauty and has been blessed with the abundance of awe-inspiring outdoor areas. From the unspoiled golden beaches,across the desola
Engineering
Random string generator
Random string are often used in web application to assign records a unique random key. Here is very useful random string generator function that allows you gene