I am trying to select group_concat in variable @s
In this process I use The data for 'results' in column is too long, but this is an error
SET session group_concat_max_len = 4294967295; SET @ query = CONCAT ('SELECT GROUP_CONCAT (\' & lt; url & gt; & lt; loc & gt; https: //www.example.com/product/ \ ', seo_url, \' .html & lt; / Loc & gt; & lt; / url & gt; \ 'SEPARATOR \' \ r \ n \ ') FROM', @ cpy, 'products WHERE web_vis_each OR web_vis_pair group_ID by ORDER, status, make, model;'); - Prepare sql_query from @query; EXQUTE sql_query;
No comments:
Post a Comment