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;