By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE blubb (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
year int(11) NOT NULL,
week int(11) NOT NULL
);
INSERT INTO blubb (year, week) VALUES (2017, 9);
INSERT INTO blubb (year, week) VALUES (2017, 11);
select concat(year, 'W', lpad(week, 2, '0')) from blubb
| concat(year, 'W', lpad(week, 2, '0')) |
|---|
| 2017W09 |
| 2017W11 |