Errors with MySQL stored function creation ERROR 1064 & 1327?
When creating a function/procedure from mysql console, the first command should be DELIMITER Otherwise, it uses default delimiter ( ).
When creating a function/procedure from mysql console, the first command should be DELIMITER //. Otherwise, it uses default delimiter (;).
Ah, I missed that when I grabbed the information out of the console. I'll fix that in the question. – Brook Julias Aug 4 '10 at 15:33.
I solved the my issues by adding `` around my variables. Here is the code I ended up with. DELIMITER // CREATE FUNCTION `modx`.
GetSTID (x VARCHAR(255)) RETURNS INT DETERMINISTIC BEGIN DECLARE `y` INT; SELECT id INTO `y` FROM `modx`. Coverage_state WHERE `coverage_state`. Name = `x`; RETURN `y`; END// DELIMITER.
I am using MySQL v5.1.36 and I am trying to create a stored function using this code. When entered into the MySQL Console I get this response. From what I can find online my syntax is correct.
What am I doing wrong?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.