MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

user variables
Posted by: gianpaolo fabiani
Date: April 08, 2005 05:09AM

why not to work?

set @list='';
SELECT @list:=group_concat(col2 SEPARATOR ", ") FROM `table1` WHERE col3 = 0 limit 1;
Select @list FROM table2 where id = 1

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
user variables
gianpaolo fabiani
April 08, 2005 05:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.