5 CREATE TABLE TestTableInsert (
8 ColumnInt INT DEFAULT 99 not null,
9 ColumnInt2 INT not null,
10 ColumnText TEXT not null,
13 CREATE TABLE TestTableDelete (
16 ColumnInt INT DEFAULT 99 not null,
17 ColumnInt2 INT not null,
18 ColumnText TEXT not null,
21 INSERT INTO TestTableDelete VALUES(1, "two", 3, 4, "five"); INSERT INTO TestTableDelete VALUES(6, "seven", 8, 9, "ten"); INSERT INTO TestTableDelete (ColumnInt2, ColumnText) VALUES(11, "twelve"); INSERT INTO TestTableDelete (ColumnInt2, ColumnText) VALUES(13, "fourteen");
28 CREATE TABLE TestTable (
31 ColumnInt INT DEFAULT 99 not null,
32 ColumnInt2 INT not null,
33 ColumnText TEXT not null,
36 INSERT INTO TestTable VALUES(1, "two", 3, 4, "five"); INSERT INTO TestTable VALUES(6, "seven", 8, 9, "ten"); INSERT INTO TestTable (ColumnInt2, ColumnText) VALUES(11, "twelve"); INSERT INTO TestTable (ColumnInt2, ColumnText) VALUES(13, "fourteen");