Hsqldb中设置主键，并让主键自增

2023-12-24 09:36:10

CREATE TABLE userinfo (
Id INTEGER GENERATED BY DEFAULT AS IDENTITY,
Name varchar(100) NOT NULL,
Department varchar(100) NOT NULL,
Status varchar(100) DEFAULT NULL,
Email varchar(200) NOT NULL,
PRIMARY KEY (Id)
)