mysql>mysql> delimiter $$mysql>mysql> CREATE FUNCTION myFunction (in_string varchar(80) ) -> RETURNS VARCHAR(256) -> NO SQL -> BEGIN -> DECLARE i INT DEFAULT 1; -> DECLARE string_len INT; -> DECLARE out_string VARCHAR(256) DEFAULT ''; -> -> SET string_len=length(in_string); -> WHILE (i<string_len) DO -> SET out_string=CONCAT(out_string,ASCII(substr(in_string,i,1)),' '); -> SET i=i+1; -> END WHILE; -> RETURN (out_string); -> -> END$$Query OK, 0 rows affected (0.00 sec)mysql>mysql> delimiter ;mysql>mysql> select myFunction('ABCDEFGHI');+--------------------------+| myFunction('ABCDEFGHI') |+--------------------------+| 65 66 67 68 69 70 71 72 |+--------------------------+1 row in set (0.00 sec)mysql>mysql> drop function myFunction;Query OK, 0 rows affected (0.00 sec)mysql>mysql>
Name (required)
email (will not be published) (required)
Website