summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/scripts/mysql/other-init.sql
blob: e3ed6b3218e2832e67c435a0da8fec3cd4c0c5bb (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

TRUNCATE `Others`;
TRUNCATE `A`;
TRUNCATE `B`;
TRUNCATE `C`;
TRUNCATE `D`;
TRUNCATE `E`;
TRUNCATE `F`;

INSERT INTO Others VALUES(1, 8888888, 0, 'Oui');
INSERT INTO Others VALUES(2, 9999999999, 1, 'Non');

INSERT INTO F VALUES('f', 'fff');
INSERT INTO E VALUES('e', 'eee');
INSERT INTO D VALUES('d', 'ddd');
INSERT INTO C VALUES('c', 'ccc');
INSERT INTO B VALUES('b', 'c', null, 'bbb');
INSERT INTO A VALUES('a', 'b', 'e', null, 'aaa');