mysql 数组类型,像PostgreSQL中一样，MySQL中是否有任何数组数据类型？

I need to store arrays of integers in a MySQL database. In there something equivalent to this in MySQL?

CREATE TABLE tictactoe (

squares integer[3][3]

);

I want to store matrices with dimension 20x6. I don't feel like creating a table with 120 columns. There is no need to query on this field, just need to store and retrieve full matrices.

If it matters, i use Perl.

解决方案

No, there is no such thing. There is an open worklog for that, but no progress has been made on implementing this feature.

You have to emulate this somehow, using either multiple fields (9 in your case) or pack the integers together into a larger datatype (blob for example).