mysql declaring and setting variables. syntax errors

Question

I thought this would be a simple task but i cannot figure out why this gives me an error in my syntax. Any help is appreciated.

DECLARE @usernameid VARCHAR(20);
declare @UserIDParam VARCHAR(20);
SET @usernameid = 'myid';
SET @UserIDParam =
   (SELECT userid
      FROM tblusers
     WHERE unid = usernameid);

SELECT *
 FROM tblusers
 WHERE tblusers.userID = @useridparam

As an aside, if that is really your entire code, why don't you just reduce the whole thing to a single SELECT query with a SQL join? — eggyal
– eggyal, Commented May 9, 2012 at 18:40

eggyal · Accepted Answer · 2012-05-09 18:33:43Z

1

One doesn't DECLARE user variables: one just uses them. (You DECLARE local variables e.g. in a procedure).

answered May 9, 2012 at 18:33

eggyal

127k18 gold badges220 silver badges244 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user222427 Over a year ago

can i get an example how to change this?

eggyal Over a year ago

@Mike: Just entirely remove the two DECLARE statements.

eggyal Over a year ago

@Mike: In your comment to Gratzy's answer, you said the error was on the DECLARE statement - how can you obtain the same error if the DECALRE statements aren't there?

user222427 Over a year ago

eggyal oh you mean remove the entire line, okay i got past that not i its at Unknown system variable 'usernameid'

eggyal Over a year ago

@Mike: You need to prefix your reference to usernameid with @ in your first SELECT statement.

|

Collectives™ on Stack Overflow

mysql declaring and setting variables. syntax errors

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related