Delimiter in MySQL

Hi Arjun,

DELIMITER statement in MySQL is used to change the standard delimiter (semicolon) to another.
for e.g ; to //  like below.....

 DELIMITER //
 CREATE PROCEDURE GetAllProducts()
   BEGIN
   SELECT *  FROM products;
   END //
 DELIMITER ;

its just to show code of stored procedure in block of //.

Thanks,
Pravin.