index.org

Bases de données

Requêtes simples

CREATE TABLE test (col1 INT PRIMARY KEY, col2);
CREATE TABLE test2 (col1, col2 INT REFERENCES test(col1));
INSERT INTO test VALUES (1,111), (2,222);
INSERT INTO test2 VALUES (1,1), (2,2);
SELECT * FROM test WHERE col1 BETWEEN 1 AND 1;
  

Fichier SQL

/* load: data.db */
/* test */
SELECT * FROM test;
  

SQL intégré

/* load: data.db */
SELECT * FROM test;
  

 

A	B
1	2
1	2