How you can create someone to many in SQLITE3? I've 2 tables:
Mans: _id name 1 antony 2 fred
point _id date point 1 23 77 24 99 2 25 78 5 0
i dont now SQL syntax, assist me to , please.
The syntax with this is the following....
CREATE TABLE (MySecondTable) Foo INT FOREIGN KEY(Foo) REFERENCES MyFirstTable(PrimaryKeyField) ON DELETE CASCASDE ON UPDATE CASCASDE
only creates v3.6.1+
Listed here are the paperwork http://sqlite.org/foreignkeys.html