KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am not an expert in sql / sqlite.. suppose we have two tables: CREATE TABLE child ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, ); CREATE TABLE MyTableB( dog TEXT, FOREIGN KEY(dogList) REFERENCES child(id) ); how will the INSERT? is correct my createTable operations? I would like to have: a child can have more than one dog a dog can have more children EDIT What if I wanted all the children and for each child a list of dogs associated with that child?
Tags (comma-separated)
Save Edits
Cancel