does mysql stored procedures support data types like array, hash,etc?
- by Yang
i am creating a mysql function which takes in a varchar and change it to a int based on a mapping table.
select name, convert_to_code(country) from users where sex = 'male'
here, the convert_to_code() function takes in a country name (e.g. Japan, Finland..) and change it to country code which is an integer (e.g. 1001, 2310..) based on a mapping…