mysql complex cluster and string

[pawhan11]

Hello

I have complex cluster with many fields and I want to write it to mysql database

My idea is to use flattern to string but when I try to write that string to database I get error because of incorrect syntax.

These strings look like this and thay cant be written int base:

Do You have any ideas how to fix it?

[Wart]

Ideally the way to handle this is to design your database so that you have an appropriately typed field in your database for each item in your cluster.  Then you can use the database toolkit to write the data by just providing a list of columns that matches the order of your cluster.

[pawhan11]

Yes, but this cluster is complex, has array and some plot inside.

So I used flattern to string and zip by openg.

Problem was that I user varchar in mysql. Using blob solved my problem 🙂