MySQL表中如何命名主键,MySQL：在CREATE TABLE语句中命名主键

How do I set the name of a primary key when creating a table?

For example here I'm trying to create a primary key with the name 'id', but this is invalid SQL. Can you tell me the correct way to do this?

CREATE TABLE IF NOT EXISTS `default_test`

(

`default_test`.`id` SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY `id`,

`default_test`.`name` LONGTEXT NOT NULL

)

Clarification

I'd like to specify the name of the primary key - rather than the default name of "PRIMARY" I'd like it to be called "id" or perhaps "primary_id", so if I were to later run SHOW INDEXES FROM default_test, the Key_name will be something I have specified.

解决方案

Alternatively and more widely supported:

CREATE TABLE IF NOT EXISTS `default_test` (

`default_test`.`id` SMALLINT NOT NULL AUTO_INCREMENT,

`default_test`.`name` LONGTEXT NOT NULL,

PRIMARY KEY (`id`)

)

UPDATE

Based on the clarification, you could replace the last definition above with the following if you are to specify the index name:

CONSTRAINT `pk_id` PRIMARY KEY (`id`)