编辑代码

CREATE TABLE ask_leave (
	id int,
    empId int,
    leaveReason text,
    beginDate date,
    endDate date,
    submitDate date,
    auditId int,
    status int,
    auditOpinion text
);

INSERT INTO ask_leave VALUES (11, '01', '事假', '2021-06-01', '2022-06-01', '2021-06-01','011',1);
INSERT INTO ask_leave VALUES (12, '02',  '事假', '2021-06-01', '2022-06-01', '2021-06-01','012',1);
INSERT INTO ask_leave VALUES (13, '03', '事假', '2021-06-01', '2022-06-01', '2021-06-01','013',1);
INSERT INTO ask_leave VALUES (14, '04',  '事假', '2021-06-01', '2022-06-01', '2021-06-01','014',1);
INSERT INTO ask_leave VALUES (15, '05', '事假', '2021-06-01', '2022-06-01', '2021-06-01','015',1);

SELECT * FROM ask_leave;