mysql同一表设置两个唯一,如何在MySQL中的两个或多个表中使用唯一ID？

在表格中要求一个唯一的id是非常罕见的,但这是一个可以做到这一点的解决方案.

/* Create a single table to store unique IDs */

CREATE TABLE object_ids (

id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

object_type ENUM('event', ...) NOT NULL

) ENGINE=InnoDB;

/* Independent object tables do not auto-increment, and have a FK to the object_ids table */

CREATE TABLE events (

id INT UNSIGNED NOT NULL PRIMARY KEY,

...

CONSTRAINT FOREIGN KEY (id) REFERENCES object_ids (id)

) ENGINE=InnoDB;

/* When creating a new record, first insert your object type into the object_ids table */

INSERT INTO object_ids(object_type) VALUES ('event');

/* Then, get the auto-increment id. */

SET @id = LAST_INSERT_ID();

/* And finally, create your object record. */

INSERT INTO events (id, ...) VALUES (@id, ...);

显然,您将复制其他表的事件表的结构.