/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

8 votes220 views1 answer
Mysql dump restore
SQL
1 vote173 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
3 votes230 views1 answer
How to get yesterday date in sql
SQL
0 vote250 views2 answers
Search stored procedures by name
SQL
1 vote163 views1 answer
Oracle user last connected
SQL
1 vote181 views1 answer
Change table to innodb mysql
SQL
0 vote129 views0 answer
SQL
0 vote170 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote163 views1 answer
Sql query to delete row by id
SQL
0 vote210 views1 answer
Best sql collation
SQL