Mike Mclaren

Asked:2020-09-08 17:15:51 +0800 CST2020-09-08 17:15:51 +0800 CST 2020-09-08 17:15:51 +0800 CST

桌子和地板柱

我有一张桌子People

CREATE TABLE People (id serial, name varchar(20), surname varchar(20), age int, gender varchar(1));

我怎样才能使它只能在性别列中输入 M 或 F 而没有其他内容。提前致谢

Best Answer

Ainar-G

像这样的东西：

CREATE TABLE people (
  id serial
, name VARCHAR(20)
, surname VARCHAR(20)
, age INT
, gender VARCHAR(1) CHECK (gender IN ('F', 'M'))
);

相关问题