一个表中可以有多个主键吗? [英] Can I have multiple primary keys in a single table?

问题描述

一个表中可以有多个主键吗?

Can I have multiple primary keys in a single table?

推荐答案

一个表可以有一个复合主键，它是由两列或更多列组成的主键.例如:

A Table can have a Composite Primary Key which is a primary key made from two or more columns. For example:

CREATE TABLE userdata (
  userid INT,
  userdataid INT,
  info char(200),
  primary key (userid, userdataid)
);

更新: 这里是链接与复合主键的更详细说明.

Update: Here is a link with a more detailed description of composite primary keys.

这篇关于一个表中可以有多个主键吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！