How to add a primary key to a MySQL table?

145

This is what I tried but it fails:

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

Does anyone have a tip?

mysql

Edit Report

0 Answers