写一个mysql8表值函数
时间: 2023-03-08 20:05:29 浏览: 71
答:我们可以使用MySQL 8的表值函数来实现,比如:CREATE FUNCTION get_employee_name (emp_id INT) RETURNS VARCHAR(50) BEGIN RETURN (SELECT name FROM employees WHERE id = emp_id); END;
相关问题
写一个mysql8表值函数,传入字符串deptcode,返回sys_dept表中dept_code值为deptcode的结果集
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的结果集,不报1064错误
CREATE FUNCTION getDeptByCode(deptcode VARCHAR(20))
RETURNS TABLE (dept_code VARCHAR(20), dept_name VARCHAR(20), dept_desc VARCHAR(100))
BEGIN
RETURN SELECT dept_code, dept_name, dept_desc FROM sys_dept WHERE dept_code = deptcode;
END