Insert auto increment primary key to existing table

by

An ALTER TABLE statement adding the PRIMARY KEY column works correctly in my testing:

ALTER TABLE tbl ADD id INT PRIMARY KEY AUTO_INCREMENT;

On a temporary table created for testing purposes, the above statement created the AUTO_INCREMENT id column and inserted auto-increment values for each existing row in the table, starting with 1.

More Related Contents:

  1. How to properly create composite primary keys – MYSQL
  2. Is there a REAL performance difference between INT and VARCHAR primary keys?
  3. difference between primary key and unique key
  4. Difference between Key, Primary Key, Unique Key and Index in MySQL
  5. auto increment primary leaving gaps in counting
  6. Remove Primary Key in MySQL
  7. ALTER TABLE to add a composite primary key
  8. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  9. MySQL InnoDB: autoincrement non-primary key
  10. Strings as Primary Keys in MYSQL Database [closed]
  11. How to make a primary key start from 1000?
  12. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  13. Multi-Column Primary Key in MySQL 5
  14. Composite Primary Key performance drawback in MySQL
  15. make an ID in a mysql table auto_increment (after the fact)
  16. Reorder / reset auto increment primary key
  17. Required to join 2 tables with their FKs in a 3rd table
  18. Setting the MySQL root user password on OS X
  19. Suppress warning messages using mysql from within Terminal, but password written in bash script
  20. Convert partially non-numeric text into number in MySQL query
  21. Can’t use a MySQL connection for entity framework 6
  22. MySQL JOIN with LIMIT 1 on joined table
  23. MySQL Select last 7 days
  24. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  25. MySQL view performance
  26. Does MySQL Regexp support Unicode matching
  27. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  28. How to retrieve JSON data from MySQL?
  29. MySQL: Compare BETWEEN time
  30. How do you force mysql LIKE to be case sensitive? [duplicate]

Leave a Comment