/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 vote216 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
-1 vote210 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote228 views2 answers
Cambiar nombre tabla mysql
SQL
1 vote231 views1 answer
Name of today sql
SQL
0 vote216 views1 answer
Add computed column to table sql server
SQL
0 vote224 views1 answer
Csv to sqlite python
SQL
0 vote207 views1 answer
Resulting Query
SQL
1 vote216 views3 answers
Psql fatal database does not exist
SQL
38 votes217 views6 answers
Alter table mysql
SQL
9 votes200 views6 answers
Sql insert into
SQL