Bug #56109 Could not create table with ARRAY datatype
Submitted: 19 Aug 2010 6:54 Modified: 19 Aug 2010 9:27
Reporter: Anil Alpati Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[19 Aug 2010 6:54] Anil Alpati
Description:
I am trying create table using array datatype since I want store integer values in array format.

i.e.. 
   column1          column2
-----------------------------
[1,2,3,4]          "Working perfectly"
[5,6]              "Currently Server is down"

I want to store records in table as mentioned above

Kindly response at your earliest. than

And the same which is working perfectly on PostgresSQL database.

How to repeat:
same as above
[19 Aug 2010 9:27] Hartmut Holzgraefe
MySQL has not implemented the ARRAY type yet,
for a list of supported data types see

http://dev.mysql.com/doc/refman/5.1/en/data-types.html

Changing severity to S5 - Feature request
[25 Aug 2010 19:14] Omer Barnir
Can't this be done using the set data type?
http://dev.mysql.com/doc/refman/5.1/en/set.html
[29 Dec 2017 20:38] Daniƫl van Eeden
This could work on 5.7 with a JSON array