Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^2: OT: SQL and me

by talexb (Canon)
on Oct 08, 2013 at 02:56 UTC ( #1057346=note: print w/replies, xml ) Need Help??


in reply to Re: OT: SQL and me
in thread OT: SQL and me

You can certainly store hierarchical data in a database, but it is a bit more complicated.

A simple example is a family tree -- each person entry would have two other people as their parent. These people would all be in the same table, so you'd have to do a join back on the table that you're selecting from.

Alex / talexb / Toronto

Thanks PJ. We owe you so much. Groklaw -- RIP -- 2003 to 2013.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1057346]
help
Chatterbox?
[choroba]: yay!
[Corion]: Ooh, yes, yay ;-D
[Discipulus]: my backpack is ready for two nights in the mountains!
[Corion]: Discipulus: In the mountains during winter?
[choroba]: SHAttered

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (6)
As of 2017-02-24 09:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (353 votes). Check out past polls.