Variable taking another variable's name as its value - MySQL

Question

SET @session = '1'; SET @session = '[@session]';
SELECT @session;

This should print -: [1] but it is printing [@session];

Whats the problem? Thanks for help..

John Woo · Accepted Answer · 2013-03-21 15:04:48Z

1

The result is as expected. [@session] was the last value that was set to variable @session.

SET @session = '1';           -- <<== first value
SET @session = '[@session]';  -- <<== second value (overrides the first value)
SELECT @session;

i think you mean,

SET @session = '1';           
SET @session = CONCAT('[', @session, ']');  
SELECT @session;

answered Mar 21, 2013 at 15:04

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

1 Comment

But i want [1]. How to get this?