MySQL: how to create table with multidimentional integer array?

Question

I'd like to know if it's possible to create a table with multidimentional integer array, I tried this syntax, but it didn't work for me unfortuantly:

create table testarray(testarr INT(20)(10));

so what to do in this case? thanks.

What are you trying to accomplish by storing trying to store an array in a relational field? — Karl Kieninger
– Karl Kieninger, Commented Apr 20, 2014 at 16:34

underscore · Accepted Answer · 2014-04-20 16:34:07Z

1

You can't. You could do something like convert your array to a comma-separated string, and store this. Use serialize function and store it into the varchar field

answered Apr 20, 2014 at 16:34

underscore

6,9277 gold badges44 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Karl Kieninger · Accepted Answer · 2014-04-20 16:45:37Z

0

No. But you could create a test array table and link to it.

CREATE TABLE testarray(ID NT, RowId INT, Element_0 INT, Element_1 INT..Element_9 INT);

Not you reference the array with testarray.ID as a foreign key from wherever you wanted to have the array original.

That's arguable better then using a comma-separated.

Or stick a json syntax array in a varchar field.

answered Apr 20, 2014 at 16:45

Karl Kieninger

9,1692 gold badges36 silver badges49 bronze badges

Collectives™ on Stack Overflow

MySQL: how to create table with multidimentional integer array?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related