Re: Variable as table-name

[Roland Bouman]

Slava,

I just found out (thanks Valeriy, see http://bugs.mysql.com/bug.php?id=15666) that there is a slightly more elegant way to deal with SELECT INTO inside prepared statements:

prepare stmt from 'SELECT col1 INTO @col1 FROM table1';

does in fact work, wich is a lot less ugly (i think) than my prior suggestion of

prepare stmt from 'SELECT @col1:=col1 FROM table1';

Also, this solutions does not make the proc return a resultset. Wich is nicer i think.



Edited 1 time(s). Last edit at 12/11/2005 08:30AM by Roland Bouman.