Delimiter in MySQL

Question

Why we have to use delimiter in MySQL commands.

Arjun Panwar · Answer

Thanks to all

Pravin More · Answer

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.

Satyapriya Nayak · Answer

Hi Arjun Please refer the below link http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html Thanks