[RESOLVED] MySQL @ operator

[reeksy]

Hi

Does anyone know what the '@' operator does in MySQL? I cant find any documentation on it!

E.g:

SELECT @myRight := rgt FROM nested_category
WHERE name = 'TELEVISIONS';


UPDATE nested_category SET rgt = rgt + 2 WHERE rgt > @myRight;
UPDATE nested_category SET lft = lft + 2 WHERE lft > @myRight;

INSERT INTO nested_category(name, lft, rgt) VALUES('GAME CONSOLES', @myRight + 1, @myRight + 2);

Full reference: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

[NogDog]

It's used in prepared statements.

[reeksy]

OK thanks