nodejs, mysql-db: handling results of query that use join

Question

I have already posted here the issue https://github.com/mariano/node-db-mysql/issues/81

When i get results of join there is bad handling of conflict of names of attributes.

Some help? Some help for modifying the c++ code and for making it working fine too.

I'm using db-mysql for a project and i don't want change it to resolve this problem. I want to avoid to substitute join with several queries executed in sequence.

Vadim Baryshev · Accepted Answer · 2012-08-08 01:46:05Z

2

This is not a bug. MySQL renamed conflicted column names automatically. If your result have conflicted column names (person for example) it will be mapped to 'person' and 'person1'. You can map conflicted columns manually to avoid default name changing. For example:

SELECT A.id, A.name, B.name AS bname, B.year FROM A INNER JOIN B ON A.id = B.a_id WHERE B.year > 2000

answered Aug 8, 2012 at 1:46

Vadim Baryshev

26.2k4 gold badges62 silver badges50 bronze badges

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

1 Comment

Giovanni Bitliner Over a year ago

This is not the problem, or this solution doesn't resolve the problem. I think the problem is in mysql-db module

Collectives™ on Stack Overflow

nodejs, mysql-db: handling results of query that use join

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related