You can store whatever you like in a blob or text-based data type, but the issue is retrieving data. Not sure what you're actually asking for though. If you have an array, you'd simply split it and pass the individual values to different fields. Equally, if you have a nested array, you'd split and possibly pass 'child' arrays (once split) into related tables.
Really not sure what advantage you'd get from storing as an array. Give us an idea of usage.
first of all I 'm sorry for my English may be I misspoke . I am currently developing an application with php that needs to show me a table like in the example below, I need to create a field that contains check boxes such as the case for the Access fields, that 's why I thought of the array type fields , so if you can explain me more clearly the relationship between the tables in this example, thank you Click Here
Sorry, I don't understand what you want. I looked at the link, but I see no connection with 'Access-like checkbox fields'.
Perhaps if you show a typical data row that you want to store.
INSERT INTO users (firstname, lastname, site_id) VALUES (?,?,?)
[get last inserted id from the above]
INSERT INTO user_access (user_id, access_id) VALUES (?,?),(?,?)... (as many as you need to insert checked access_ids)
Update is a little trickier.
Another approach is to use bitwise operators - fine if you have less than 32 types of access. Any more and it won't work on 32-bit servers.