Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Answer: How do I get "table.column" format from a select/join?

( #739361=categorized answer: print w/ replies, xml ) Need Help??

Q&A > database programming > How do I get "table.column" format from a select/join? contributed by derobert

Do not use SELECT *. Not only are you probably pulling far more data than you need (which may or may not matter, depending on how big that data is) but as you've noticed, duplicate field names are problematic and make your code fragile (what happens when the DBA adds another column?). Instead, select exactly the columns you need, and under the names you want:
SELECT p.gene_id AS parent_gene_id, c.gene_id AS child_gene_id, AS child_name FROM parent p LEFT JOIN child c ON ( p.gene_id = c.gene_id ) /* etc. */

Comment on Answer: How do I get "table.column" format from a select/join?
Select or Download Code
Log In?

What's my password?
Create A New User
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (18)
As of 2015-11-24 22:20 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (664 votes), past polls