Add Auto-Increment ID to existing table?

by

Try this

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT;

for an existing primary key

More Related Contents:

  1. How to reset AUTO_INCREMENT in MySQL
  2. SQL: Creating a Relational table with 2 different auto_increment
  3. How to insert data to MySQL with auto-incremented column(field)?
  4. INSERT INTO SELECT statement with more columns which is not in another table
  5. MySQL how to fill missing dates in range?
  6. Left Outer Join doesn’t return all rows from my left table?
  7. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  8. How to split the name string in mysql?
  9. Can a foreign key reference a non-unique index?
  10. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  11. How to set a maximum execution time for a mysql query?
  12. Get the latest date from grouped MySQL data
  13. SQL keys, MUL vs PRI vs UNI
  14. Cast int to varchar
  15. Import SQL file into mysql
  16. MySQL SELECT last few days?
  17. “where 1=1” statement [duplicate]
  18. Split a string and loop through values in MySQL stored procedure
  19. how to cast the hexadecimal to varchar(datetime)?
  20. MySQL Select Query – Get only first 10 characters of a value
  21. How to get a list of months between two dates in mysql
  22. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  23. Postgres LEFT JOIN with WHERE condition
  24. How to check if field is null or empty in MySQL?
  25. mysql select id and name from other table and join query
  26. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. MySQL update statement to store ranking positions
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment