What is the purpose of OUT in MySQL stored procedures?

[J100200]

What is the purpose of \[code\]OUT\[/code\] in MySQL stored procedures?If I have a simple stored procedure which looks like this:\[code\]DELIMITER $$CREATE DEFINER=`root`@`localhost` PROCEDURE `new_routine`( IN iID int)BEGIN select * from table1 where id = iID;END\[/code\]This would give me all the results I want by running:\[code\]call new_routine(7);\[/code\]So why would I want/need to use \[code\]OUT\[/code\]?\[code\]DELIMITER $$CREATE DEFINER=`root`@`localhost` PROCEDURE `new_routine`( IN iID int, OUT vName varchar(100))BEGIN select name into vName from table1 where id = iID;END\[/code\]and call it like this\[code\]call new_routine(7, @name);select @name;\[/code\]Which will give me just the name instead of everything from the rows returned?I've tried Googling, but clearly haven't asked Google the right question to get a clear answer.