CREATE FUNCTION getDeptByCode(deptcode VARCHAR(20)) RETURNS TABLE (dept_id INT, dept_name VARCHAR(50), dept_code VARCHAR(20)) BEGIN RETURN SELECT * FROM sys_dept WHERE dept_code = deptcode; END;
写一个mysql8表值函数,传入字符串deptcode,返回sys_dept表中dept_code值为deptcode的结果集...
最新推荐文章于 2024-10-23 23:38:47 发布