DELIMITER $$ CREATE FUNCTION F_TEST(uid INT) BEGIN DECLARE username VARCHAR DEFAULT ""; SELECT username INTO username FROM users WHERE ID = uid; RETURN username; END