MySQL 添加约束 - employee 表示例

ALTER TABLE employee ADD CONSTRAINT pk_employee_id PRIMARY KEY (id); ALTER TABLE employee ALTER COLUMN name SET NOT NULL; ALTER TABLE employee ALTER COLUMN Brithday SET NOT NULL; ALTER TABLE employee ALTER COLUMN job SET NOT NULL; ALTER TABLE employee ALTER COLUMN Salary SET DEFAULT 2000;