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');

6th Mar 2020, 4:55 AM
Carlos Collado
Carlos Collado - avatar
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
14th Mar 2020, 8:24 AM
Ipang