Syntax error ?

[Joshua42]

Hi,

I am new to MySQL. Up to now I never needed Transact SQL, but now I have learned it can be useful . MySQL rejects the message Syntax error in insert. Any ideas what I did wrong?

Thanks in advance,
Josh

Here is my Code:

BEGIN
DECLARE @right_most_sibling INTEGER;
SET @right_most_sibling = SELECT rgt FROM personnel WHERE
emp ='Joshua';

UPDATE personnel SET lft = CASE WHEN lft >
@right_most_sibling
THEN lft+2
ELSE lft END,
rgt =CASE WHEN rgt >= @right_most_sibling
THEN rgt +2
ELSE rgt END
WHERE rgt >= @right_most_sibling

INSERT INTO personnel (emp, lft, rgt)
VALUES ('New GUY', @right_most_sibling,
(@right_most_sibling +1))
END;

 

[sleipnir214]

MySQL doesn't use BEGIN and END. It uses START TRANSACTION and COMMIT. (

http://www.mysql.com/doc/en/COMMIT.html).

MySQL also does not support transactions with all table types. You will have to use the InnoDB or BDB table types. (

http://www.mysql.com/doc/en/ANSI_diff_Transactions.html)

MySQL doesn't use DECLARE for user-defined variables. It uses SET. (

http://www.mysql.com/doc/en/Variables.html)

IF, THEN, ELSE are not block-operators in MySQL. You might want to take a look at the IF() function. (

http://www.mysql.com/doc/en/Control_flow_functions.html)

Multiple statements in a block are terminated by semicolons in MySQL.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!