Difference between revisions of "Create a simple test table"
From MyWiki
(Created page with "<source lang="sql"> create table lib ( name varchar(32), dept varchar(32), out number ); </source>") |
|||
| 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',3); | ||
| + | INSERT INTO LIB VALUES('pete','physics',3); | ||
| + | INSERT INTO LIB VALUES('roger','physics',3); | ||
| + | INSERT INTO LIB VALUES('john','history',3); | ||
| + | INSERT INTO LIB VALUES('rich','finance',3); | ||
| + | INSERT INTO LIB VALUES('blue','finance',3); | ||
| + | INSERT INTO LIB VALUES('cheese','it',3); | ||
| + | INSERT INTO LIB VALUES('ray','it',3); | ||
| + | INSERT INTO LIB VALUES('blue','it',3); | ||
| + | INSERT INTO LIB VALUES('green','history',3); | ||
</source> | </source> | ||
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',3); INSERT INTO LIB VALUES('pete','physics',3); INSERT INTO LIB VALUES('roger','physics',3); INSERT INTO LIB VALUES('john','history',3); INSERT INTO LIB VALUES('rich','finance',3); INSERT INTO LIB VALUES('blue','finance',3); INSERT INTO LIB VALUES('cheese','it',3); INSERT INTO LIB VALUES('ray','it',3); INSERT INTO LIB VALUES('blue','it',3); INSERT INTO LIB VALUES('green','history',3);
