rgncycle-db/readme.md

8 lines
376 B
Markdown

* connect to database like [this](./doc/connect2db.md)
* create initial database like [this](./doc/create-db.md)
* SQL query for all relations belonging to a specific entity
```
select entities.entity_id,entities.entity_name, relations.relation_to_entity from entities,relations where relations.relation_from_entity=6 and entities.entity_id=relations.relation_to_entity;
```