add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `Periods` (
`id` INT,
`names` VARCHAR(50)CHARACTER SET UTF8MB4 COLLATE UTF8MB4_0900_AI_CI DEFAULT NULL
) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=UTF8MB4 COLLATE = UTF8MB4_0900_AI_CI;
CREATE TABLE `Tier` (
`id` INT,
`sYear` INT,
`days` INT
) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=UTF8MB4 COLLATE = UTF8MB4_0900_AI_CI;
INSERT INTO `Periods` (`id`,`names`) VALUES (1,'Simon'), (2,'Davis');
INSERT INTO `Tier` (`id`,`sYear`,`days`)
VALUES
(1,0,0),
(1,1,21),
(1,5,30),
(2,0,0),
(2,1,26),
(2,5,30)
;


SELECT
*
FROM
`Periods`;

SELECT
*
FROM
`Tier`;

id names
1 Simon
2 Davis
id sYear days
1 0 0
1 1 21
1 5 30
2 0 0
2 1 26
2 5 30
id days names Result
2 0 Davis 0
2 26 Davis 26
2 30 Davis 30