How can I create a array of tables using INNER JOIN with node-mysql?

Question

When using node-mysql, this select SELECT shop.shopId, shop.name, address.address FROM shop INNER JOIN address ON shop.shopId = address.shopId returns a json like that:

[{
     "shopId":1,
     "name":"Lorem",
     "street":"Street XXXXX"
},{
     "shopId":1,
     "name":"Lorem",
     "street":"Street YYYYY"
},{
     "shopId":2,
     "name":"Ipsum",
     "street":"Street ZZZZZ"
}]

But what I need is something like this

[{
     "shopId":1,
     "name":"Lorem",
     "street":[{"Street XXXXX"},{"Street YYYYY"}]
},{
     "shopId":2,
     "name":"Ipsum",
     "street":"Street ZZZZZ"
}]

How could i do that using node-mysql? Knex or sequelize can do it?

Ujjwal Mishra · Accepted Answer · 2016-05-24 19:21:34Z

2

Try adding GROUP BY shopId . I guess changing the Sql string can give you desired results.

answered May 24, 2016 at 19:21

Ujjwal Mishra

951 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

How can I create a array of tables using INNER JOIN with node-mysql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related