How to store array values in single column in MySQL and Node.js?

Question

Can I store array values in single column in MySQL? since I have an array and want to store in database like here is some stuff which I want to execute.

var meida_array=[];
var media_length=response.media.length;
for(var i=0;i<media_length;i++){
   var parsed = url.parse(response.media[i]['link']);
   meida_array.push(parsed.host + parsed.path)
}
for (var i = 0; i < meida_array.length; i++) {
   console.log(meida_array[i]);
}

I am getting the array but stuck in to store in database Thanks, in advance :)

jamseernj · Accepted Answer · 2014-11-19 08:10:56Z

7

Use Json stringify and store in database

var stringObj = JSON.stringify(meida_array);

answered Nov 19, 2014 at 8:10

jamseernj

1,05211 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to store array values in single column in MySQL and Node.js?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related