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!