declare myvar int(11); in mysql routine returns syntax error

I had a very long routine that used to work on a previous server. I migrated it to a new server and I started having sql syntax error.

So I did a test:

create procedure test()
begin

declare myvar int(11);

sele开发者_如何学Cct myvar;

end

By running this in mysql or in Mysql Workbench you should have a syntax error at 11) just before the ;

What's going on!

I've looked at mysql references on the subject they say declare [variablename] [datatype]

I've tried with other data types just to make sure I still get the same problem.

thanks in advance for your help.

When you declare variables you don't give them display lengths. Those numbers are meant for table column definitions only.

Just do

DECLARE myvar INT;

Additionally declare would be first statement after begin. otherwise this will always give error.