Difference between revisions of "Create a simple test table"

From MyWiki
Jump to: navigation, search
 
Line 11: Line 11:
 
<source lang="sql">
 
<source lang="sql">
 
INSERT INTO LIB VALUES('ben','history',3);
 
INSERT INTO LIB VALUES('ben','history',3);
−
INSERT INTO LIB VALUES('amy','history',3);
+
INSERT INTO LIB VALUES('amy','history',4);
−
INSERT INTO LIB VALUES('pete','physics',3);
+
INSERT INTO LIB VALUES('pete','physics',5);
 
INSERT INTO LIB VALUES('roger','physics',3);
 
INSERT INTO LIB VALUES('roger','physics',3);
−
INSERT INTO LIB VALUES('john','history',3);
+
INSERT INTO LIB VALUES('john','history',7);
 
INSERT INTO LIB VALUES('rich','finance',3);
 
INSERT INTO LIB VALUES('rich','finance',3);
−
INSERT INTO LIB VALUES('blue','finance',3);
+
INSERT INTO LIB VALUES('blue','finance',8);
−
INSERT INTO LIB VALUES('cheese','it',3);
+
INSERT INTO LIB VALUES('cheese','it',2);
−
INSERT INTO LIB VALUES('ray','it',3);
+
INSERT INTO LIB VALUES('ray','it',0);
−
INSERT INTO LIB VALUES('blue','it',3);
+
INSERT INTO LIB VALUES('blue','it',1);
 
INSERT INTO LIB VALUES('green','history',3);
 
INSERT INTO LIB VALUES('green','history',3);
 
</source>
 
</source>

Latest revision as of 08:41, 4 August 2021

CREATE TABLE lib
(
name VARCHAR(32),
dept VARCHAR(32),
OUT NUMBER
);


Fill the table with some test values

INSERT INTO LIB VALUES('ben','history',3);
INSERT INTO LIB VALUES('amy','history',4);
INSERT INTO LIB VALUES('pete','physics',5);
INSERT INTO LIB VALUES('roger','physics',3);
INSERT INTO LIB VALUES('john','history',7);
INSERT INTO LIB VALUES('rich','finance',3);
INSERT INTO LIB VALUES('blue','finance',8);
INSERT INTO LIB VALUES('cheese','it',2);
INSERT INTO LIB VALUES('ray','it',0);
INSERT INTO LIB VALUES('blue','it',1);
INSERT INTO LIB VALUES('green','history',3);
Retrieved from "https://wiki.twig.es/index.php?title=Create_a_simple_test_table&oldid=4836"