/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 vote369 views1 answer
Sql server rtrim everything after character
SQL
7 votes369 views1 answer
Oracle alter sequence restart start with
SQL
4 votes367 views1 answer
For loop postgresql
SQL
0 vote354 views1 answer
How get data from database if id not found then search another column
SQL
28 votes319 views6 answers
Distinct sql
SQL
0 vote337 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
7 votes375 views1 answer
Sql disable safe mode
SQL
11 votes374 views4 answers
MYSQL LOGIN
SQL
0 vote376 views1 answer
Ajouter une clé etrangere mysql
SQL
1 vote345 views2 answers
Update with inner join sql server
SQL