Difference between revisions of "Create a simple test table"

From MyWiki
Jump to: navigation, search
(Created page with "<source lang="sql"> create table lib ( name varchar(32), dept varchar(32), out number ); </source>")
 
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:
 
out number
 
out number
 
);
 
);
 +
</source>
 +
<br>
 +
Fill the table with some test values<br>
 +
<source lang="sql">
 +
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);
 
</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"