1 Reply Latest reply: Apr 18, 2012 4:04 PM by Jason Michaelides RSS

    Assign SQL result to script variable



      I would like to assign the result of an SQL request in a script variable:


      SET var='';


      SELECT CONCAT(id,';') AS idlist

      FROM table;


      How do I assign idlist value (for example '1;5;7;10') to var?


      I tried var=idlist but get an empty result.