Variables in procedures - MySQL
Posted: Wed Jan 27, 2010 2:55 pm
How come all my variables but 'mytable' is working?
Errormessage: table mytable does not exist.
My passed tablename does not appear.
Code: Select all
DELIMITER $$
CREATE PROCEDURE add_child2 (IN mytable CHAR(40), IN myparent CHAR(40), IN mynew CHAR(40))
BEGIN
DECLARE myLeft INT;
SELECT lft INTO myLeft FROM mytable WHERE name = myparent;
UPDATE mytable SET rgt = rgt + 2 WHERE rgt > myLeft;
UPDATE mytable SET lft = lft + 2 WHERE lft > myLeft;
INSERT INTO mytable(name, lft, rgt) VALUES(mynew, myLeft + 1, myLeft + 2);
END$$
DELIMITER ;
My passed tablename does not appear.