Can we store List type of data to MYSQL database table?

Question

I need to store some data of list type into a MYSQL database.Is it possible to store it in MYSQL,if yes then what should be the data type of the field that will hold this data?

Thanks in advance.

Answer 1

No, no, no, no, no! Never store multiple values in a single column!

Seperate the values and store each of them in another record.

For instance if you have users and want to store a list of the roles each user has then you can do it like this

users table
-----------
id
name
...


roles table
-----------
id
name


user_roles table
----------------
user_id
role_id

Answer 2

You can use JSON datatype. MySQL provides JSON as column data type and provides some functions to work with JSON data.

Look at the documentation

NOTE: you must use 5.7+ version

As of MySQL 5.7.8, MySQL supports a native JSON data type that enables efficient access to data in JSON