News for hackers. Stuff that matters.

A comment on SQL style guide. Parent comment

Re:SQL style guide by andreareina on Sunday October 09, 2016 @01:39PM (#12672261)
I think the author was talking about (not) using `id` as the column name, e.g. `user.user_id` instead of `user.id`
[ Parent | on HN ]
Re:SQL style guide by webbore on Sunday October 09, 2016 @02:50PM (#12672713)
ON second reading I think you are correct. I agree on this point then, as it helps when joining through a denormalized table that references multiple PK ids, ex: I think: user_id = role_id is more readable than the likely alternative: u.id = r.id
[ Parent | on HN ]
Re:SQL style guide by NickNameNick on Monday October 10, 2016 @01:32AM (#12675249)
it also lets you use the join foo using(foo_id) syntax, which I quite like
[ Parent | on HN ]