PROCEDURE 过程参数

传参数值 PROCEDURE `getMarksVerify` (archivesId INT)  

传参大数值 PROCEDURE `addMarksVerify`(phone BIGINT)

传参日期 PROCEDURE `addMarks`(archivesId BIGINT,signData date,points INT)

INSERT INTO community_people (dept_id,dept_name,sign_time,score,
archives_id,create_user_id,create_user_name,create_time) VALUES
(808,'部门名称',signData,points,
archivesId,37176,'创建名字',NOW());

posted @ 2022-09-24 09:55  寒冷的雨呢  阅读(57)  评论(0编辑  收藏  举报