1 | SET names utf8mb4;
|
---|
2 |
|
---|
3 | USE Macroniser;
|
---|
4 |
|
---|
5 | INSERT INTO MarkedWords (marked_word) VALUES
|
---|
6 | ('dÅg'),('lÄx'),('whÄle'),('Åstrich');
|
---|
7 |
|
---|
8 | INSERT INTO EntryDates (entry_date) VALUES
|
---|
9 | ('2018-01-01'),('2018-02-02'),('2018-03-03'),('2018-04-04');
|
---|
10 |
|
---|
11 | INSERT INTO EntryTimes (entry_time) VALUES
|
---|
12 | ('09:00:09'),('10:10:10'),('21:11:11'),('23:23:23');
|
---|
13 |
|
---|
14 | INSERT INTO Occurrences (word_id, time_id, date_id) VALUES
|
---|
15 | (1, 1, 1), (2, 2, 2), (3, 3, 3), (1, 4, 1), (4, 4, 4);
|
---|
16 |
|
---|
17 |
|
---|
18 | Select o.occurrence_id, mw.marked_word, ed.entry_date, et.entry_time
|
---|
19 | FROM Occurrences o, MarkedWords mw, EntryDates ed, EntryTimes et
|
---|
20 | WHERE o.word_id = mw.word_id
|
---|
21 | AND o.date_id = ed.date_id
|
---|
22 | AND o.time_id = et.time_id;
|
---|