Change type / len of a user defined column in My SQL Workbench

111
August 29, 2021, at 02:00 AM

I am using a MySQL query in Workbench that uses group_concat() to group multiple string values.

select group_concat(iba.name, '   ' separator "--") as Entity_Business_Activity 
from entity_business_activities ent_eba
left join entities ent on ent.entity_id = ent_eba.entity_id # for entity Business Activity
left join industries ent_ind on ent_eba.industry_id = ent_ind.industry_id # Needs a group concat
left join industry_business_activities iba on ent_eba.industry_business_activity_id = iba.industry_business_activity_id #(need to be group concat)
where ent.entity_id = 600
group by ent.entity_id;

Here is a sample Output.

The issue that I am facing here is the grouped string values are too long, sometimes increasing 2000 characters. But only 1024 characters are extracted and the rest skipped.

Is there any way that I can set the Type of this Custom Column or any possibility to increase the character length?

Rent Charter Buses Company
READ ALSO
Is there a way to bypass anonymising service check?

Is there a way to bypass anonymising service check?

I have been dabbling with python and selenium for a while nowI Was trying to work with a website, and as I realize that I may have to make multiple calls to the site, and to avoid any ip related issue, I tried to use proxy

110
Adding swatches to a mail template without using a layout

Adding swatches to a mail template without using a layout

I am working on a mail template and I would like to ask if it's possible to add the colour swatches functionality to aphtml

130
How do i add functionality to my nav dots in my image slider?

How do i add functionality to my nav dots in my image slider?

Currently my nav dots do not have any functionalityHow do i add that

51
Get value from XML with keyup

Get value from XML with keyup

I'm trying to work this out, I have an HTML form, I'm currently able to fetch all details from XML to the form input fields via jQueryBut I'm trying to be able to fill out each field based on the Number field, so when I type in the number it fetches the rest of the details...

114