Menu
I am creating a botanical database where the plants will be organized by their taxonomy:
Life Domain Kingdom Phylum Class Order Family Genus Species
I was considering using the example put forth by the article Managing Hierarchical Data in MySQL, however it is adding the above list as records inside the table....and I'm not sure if that is the best thing to do since I will be having multiple species per genus and multiple genus per family and so on. What would you suggest is the best way to approach this problem. Thanks in advance.
605
Taxonomy: A classification system used for analysis or information retrieval. UNION Query: By inserting the key word UNION between multiple SQL SELECT statements, the resulting rows from these statements are appended into a single result set (provided the number and data types of the columns match).
The DESC is the short form of DESCRIBE command and used to dipslay the information about a table like column names and constraints on column name. The DESCRIBE command is equivalent to the following command − SHOW columns from yourTableName command.
It sounds more like a graph. I'd wonder if NEO4J would be a better choice.
128
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
