Code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `table_upd` (IN customer_id int, IN cname_param VARCHAR(45),IN lastname_param VARCHAR(45), IN date_of_birth_param DATE, IN country_param VARCHAR(45), IN email_param VARCHAR(100), IN username_param VARCHAR(45), IN short_biography_param