MySQL - What data type should I use to store a Map field

Question

I have a field on my Java object that is type

Map<String, ArrayList<Integer>>

and I am trying to figure out the best way to store it in a MySQL database. Does anyone have any suggestions as to what data type I should use?

Answer 1

You need to learn about relational databases and normalization.

You won't be storing a Map in MySQL. I can see a one-to-many relationship between two tables, where the parent is the table with the String key and the child is the one with many integer row values.