how to store 2d array in mysql table

eclipse3.4ide · #1 (**permalink**) 02-02-09, 09:31

hi,
how to save 2D array in mysql table. can anyone please give me the query...........
regards
eclipse3.4ide

r937 · #2 (**permalink**) 02-02-09, 09:57

Code:

CREATE TABLE my_2d_array
( x INTEGER NOT NULL 
, y INTEGER NOT NULL 
, PRIMARY KEY ( x , y )
, cellvalue INTEGER NOT NULL DEFAULT 0
);

eclipse3.4ide · #3 (**permalink**) 02-04-09, 01:19

can u please give me the sample insert query for storing the values into database...

r937 · #4 (**permalink**) 02-04-09, 06:21

Code:

INSERT
  INTO my_2d_array
     ( x, y, cellvalue )
VALUES
     ( 1, 1, 321 )
   , ( 1, 2, 432 ) 
   , ( 1, 3, 654 ) 
   , ( 1, 4, 876 ) 
   , ( 2, 1, 567 ) 
   , ( 2, 2, 937 ) 
   , ...

Internet Services

Web Development

Digital Marketing

Consumer Tech