/SQL/Create more than 1 tables with references to each other in sqlite3

Create more than 1 tables with references to each other in sqlite3

DROP TABLE suppliers;

CREATE TABLE suppliers (
    supplier_id   INTEGER PRIMARY KEY,
    supplier_name TEXT    NOT NULL,
    group_id      INTEGER NOT NULL,
    FOREIGN KEY (group_id)
       REFERENCES supplier_groups (group_id) 
);
Code language: SQL (Structured Query Language) (sql)

Source: sqlitetutorial.net

Create more than 1 tables with references to each other in sqlite3

INSERT INTO suppliers (supplier_name, group_id)
VALUES('XYZ Corp', 1);

INSERT INTO suppliers (supplier_name, group_id)
VALUES('ABC Corp', 2);
Code language: SQL (Structured Query Language) (sql)

Source: sqlitetutorial.net

Similar codes

9 votes377 views3 answers
Date format in sql
SQL
0 vote401 views1 answer
Reindex mssql table
SQL
5 votes358 views2 answers
Update all rows mysql
SQL
0 vote381 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote355 views2 answers
How to display enum value sql server
SQL
0 vote387 views1 answer
Mql5 datetime get hour
SQL
5 votes398 views4 answers
Traduction
SQL
24 votes370 views4 answers
Delete db postgres
SQL
0 vote370 views2 answers
Update all columns in one update
SQL
14 votes351 views3 answers
SQL trim
SQL