MySQL could not to define variables with DECLARE

Question

in mysql editor i can not define simple variables with DECLARE such as:

DECLARE v_delay INT DEFAULT 0 ;

i get this error now:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE v_delay INT DEFAULT 0' at line 1

http://stackoverflow.com/questions/11754781/declare-a-variable-in-mysql — nobalG, Jul 23 '14 at 10:21

score 0 · Accepted Answer · answered Jul 23 '14 at 10:21

0

In MySQL you can only declare in a function, procedure, trigger, event, ....

You need a shell around your code if it is more than a query

answered Jul 23 '14 at 10:21

juergen d

201,996
37
293
362

MySQL could not to define variables with DECLARE

1 Answers1