/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

0 vote197 views1 answer
Compress sql file database ubuntu
SQL
0 vote198 views1 answer
Show specific events on mysql
SQL
8 votes167 views2 answers
Change name of colum in sql table
SQL
0 vote162 views1 answer
Duplicate value unique constraint mysql error
SQL
1 vote186 views1 answer
Tsql replace value in json
SQL
8 votes134 views8 answers
Second highest salary in mysql
SQL
0 vote157 views1 answer
Postgresql newline character
SQL
0 vote186 views2 answers
How to know the character set of an oracle databes
SQL
1 vote165 views1 answer
Psql client write to bash variable
SQL
7 votes158 views1 answer
Forge server hosting
SQL