如何在MySQL表中添加主键? [英] How to add a primary key to a MySQL table?

问题描述

这是我尝试过的，但失败了:

This is what I tried but it fails:

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

有人给小费吗?

推荐答案

添加列之后，您始终可以添加主键:

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

ALTER TABLE goods ADD PRIMARY KEY(id)

关于为什么脚本无法正常工作，您需要指定PRIMARY KEY，而不仅仅是单词PRIMARY:

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;

这篇关于如何在MySQL表中添加主键?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！