Create a simple test table - Revision history

George2 at 08:41, 4 August 2021

2021-08-04T08:41:52Z

2021-08-04T08:41:09Z

2021-08-04T08:36:16Z

Created page with "<source lang="sql"> create table lib ( name varchar(32), dept varchar(32), out number ); </source>"

New page

<source lang="sql">
create table lib
(
name varchar(32),
dept varchar(32),
out number
);
</source>

@@ Line 11: / Line 11: @@
 <source lang="sql">
 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('john','history',3);
+INSERT INTO LIB VALUES('john','history',7);
 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);
 </source>

@@ Line 6: / Line 6: @@
 out number
 );
 </source>