How to add a primary key to a MySQL table?

by

After adding the column, you can always add the primary key:

ALTER TABLE goods ADD PRIMARY KEY(id)

As to why your script wasn’t working, you need to specify PRIMARY KEY, not just the word PRIMARY:

alter table goods add column `id` int(10) unsigned primary KEY AUTO_INCREMENT;

More Related Contents:

  1. MySQL – Get row number on select
  2. Delimiters in MySQL
  3. How to use GROUP_CONCAT in a CONCAT in MySQL
  4. MySQL query / clause execution order
  5. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  6. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  7. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  8. Operand Should Contain 1 Column – MySQL NOT IN
  9. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  10. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  11. On duplicate key ignore? [duplicate]
  12. How to convert timestamp to datetime in MySQL?
  13. List of Stored Procedures/Functions Mysql Command Line
  14. Best practices for SQL varchar column length [closed]
  15. How to design a multi tenant mysql database
  16. How to get the count of each distinct value in a column? [duplicate]
  17. Get results that fall within marker radiuses from database
  18. Bash script to insert values in MySQL
  19. What are differences between INSERT and UPDATE in MySQL?
  20. MySQL dynamic cross tab
  21. ERROR: Loading local data is disabled – this must be enabled on both the client and server sides
  22. How do I split the output from mysqldump into smaller files?
  23. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  24. Where does MySQL store database files on Windows and what are the names of the files?
  25. MySQL Group By Hours
  26. RMySQL dbWriteTable with field.types
  27. MySql Query Replace NULL with Empty String in Select
  28. How to handle a query with special characters / (forward slash) and \ (backslash)
  29. Does MySQL support historical date (like 1200)?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment