Except for Example 5, the following input applies to the examples.
CREATE TABLE words_input (
id INTEGER,
word VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( id );
insert into words_input values(1, 'regression');
insert into words_input values(2, 'Roger');
insert into words_input values(3, 'better');
insert into words_input values(4, 'datum');
insert into words_input values(5, 'quickly');
insert into words_input values(6, 'proud');
insert into words_input values(7, 'father');
insert into words_input values(8, 'juniors');
insert into words_input values(9, 'doing');
insert into words_input values(10, 'being');
insert into words_input values(11, 'negating');
insert into words_input values(12, 'yearly');
InputTable: words_input
| id | word |
|---|---|
| 1 | regression |
| 2 | Roger |
| 3 | better |
| 4 | datum |
| 5 | quickly |
| 6 | proud |
| 7 | father |
| 8 | juniors |
| 9 | doing |
| 10 | being |
| 11 | negating |
| 12 | yearly |