0
Alguien sabe si esto está bien o mal? Y su explicación! Por favor
DELIMITER // CREATE PROCEDURE country_hos (IN con CHAR(20)) BEGIN SELECT Name, HeadOfState FROM Country WHERE Continent = con; END // DELIMITER ; CALL country_hos('Europe');
1 ответ
+ 1
DELIMITER is a command line instruction for defining a custom statement delimiter. When defining a block of instruction (procedure etc), where use of default statement delimiter may be necessary, a customized statement delimiter is needed in order to prevent the SQL engine from misinterpreting where the block actually ends, if the engine finds a statement delimiter inside the block.
More about it:
https://stackoverflow.com/questions/10259504/delimiters-in-mysql