Tools :: Webmaster Tutorials :: Topic [Reorder Primary Key]

PasswordSentry

Latest Version [8.00202307241] Last Updated [Jul-24-2023]

Tools

Webmaster Tutorials

Home

Reorder Primary Key

You can reorder a primary key (e.g., ID) by execcuting the following three(3) mySQL queries (via command line or app like phpMyAdmin):

ALTER TABLE `tbl` DROP `col`;
ALTER TABLE `tbl` AUTO_INCREMENT = 1;
ALTER TABLE `tbl` ADD `col` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

- Replace tbl with the name of your database table.
- Replace col with the name of the column in the database table you are reordering.

Warning: Do NOT reorder a column if another database table uses that same column for reference. Otherwise, the tables will be out of sync.
Once changed, the changes cannot be undone. Always backup your database table before you make sweeping changes like this. That way,
if anything goes wrong, you can restore the database table from your backup.

Random Security Blog Articles

See All Blog Posts

Blindly eliminating biases from AI systems can have unintended consequences. Dimitri Otis/DigitalVision via Getty Images Emilio Ferrara, University of Southern California When I asked ChatGPT for a joke about Sicilians the other day, it implied that Sicilians are stinky.… Read More

seaonweb/Shutterstock Christopher J. Finlay, Durham University In conventional warfare, it’s accepted that if a state finds itself under attack, it’s entitled to respond – either with defensive force, or with a counterattack. But it’s less clear how countries should … Read More

Scroll

#1 Web Enterprise Software Application in its class! Better App for Better Security! Free Open Source Security App!