mysql> mysql> delimiter $$ mysql> mysql> CREATE PROCEDURE myProc() -> BEGIN -> DECLARE l_varchar VARCHAR(255) DEFAULT 'This will not be padded'; -> -> select l_varchar; -> END$$ Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ; mysql> mysql> call myProc(); +-------------------------+ | l_varchar | +-------------------------+ | This will not be padded | +-------------------------+ 1 row in set (0.00 sec)