Forgiving, yes, but usually not /that/ forgiving. It's certainly caused
some wasted time going down the wrong path trying to debug an issue.
On Mon, Jun 10, 2019 at 3:39 PM Richard Hipp wrote:
> On 6/10/19, Shawn Wagner wrote:
> > Consider:
> >
> > CREATE TABLE a(id INTEGER PRIMARY KEY);
> >
On 6/10/19, Shawn Wagner wrote:
> Consider:
>
> CREATE TABLE a(id INTEGER PRIMARY KEY);
> CREATE TABLE b(id INTEGER PRIMARY KEY);
> CREATE TABLE c(id INTEGER PRIMARY KEY, a_id, b_id,
>FOREIGN KEY (a_id) REFERENCES a(id)
>FOREIGN KEY (b_id) REFERENCES b(id));
>
>
Consider:
CREATE TABLE a(id INTEGER PRIMARY KEY);
CREATE TABLE b(id INTEGER PRIMARY KEY);
CREATE TABLE c(id INTEGER PRIMARY KEY, a_id, b_id,
FOREIGN KEY (a_id) REFERENCES a(id)
FOREIGN KEY (b_id) REFERENCES b(id));
Note the lack of comma between the two foreign key
3 matches
Mail list logo