Re: How to transform a field with comma separated string in to fields

SH Chien <[email protected]> Thu, 24 Nov 2022 17:23:56 -0800 (PST)
Newsgroups comp.databases.mysql
Message-ID <[email protected]>
Jerry Stuckle 在 2022年11月25日 星期五凌晨1:43:20 [UTC+8] 的信中寫道:
> You probably could do it, but it wouldn't be easy. 
> 
> But your real problem here is how your data is stored. It does not 
> follow first normal form - it has multiple values in a single column. 
> Better would be to parse the output of your workload manager or 
> otherwise see if you can change the format. What you have will cause 
> you no end of problems. 
> 
Noted with thanks!