DELIMITER //

CREATE FUNCTION getCustomerName(CustomerID INT UNSIGNED) 

RETURNS VARCHAR(100)

BEGIN

DECLARE CustomerName VARCHAR(100);

SELECT name from xyx_customer where customer_id = CustomerID INTO CustomerName;

RETURN CustomerName;

END//