1.主键是保证数据中的唯一性,
2.且只能存在一个主键,
3.主键自动为NOT NULL,
CREATE TABLE tb3(
id SMALLINT UNSIGNED PRIMARY KEY,
username VARCHAR(20) NOT NULL
);
CREATE TABLE tb4(
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(20) NOT NULL
);
1.主键是保证数据中的唯一性,
2.且只能存在一个主键,
3.主键自动为NOT NULL,
CREATE TABLE tb3(
id SMALLINT UNSIGNED PRIMARY KEY,
username VARCHAR(20) NOT NULL
);
CREATE TABLE tb4(
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(20) NOT NULL
);