MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (io_1 BOOLEAN, driver VARCHAR(15));
INSERT INTO test VALUES
(1, '17EB0C401000065'),
(1,0),
(1,0),
(1,0),
(1,0),
(1,0);
SELECT * FROM test;

Records: 6  Duplicates: 0  Warnings: 0




io_1
driver


1
17EB0C401000065

1
0

1
0

1
0

1
0

1
0


UPDATE test
CROSS JOIN ( SELECT MAX(driver) driver
             FROM test ) data
SET test.driver = data.driver
WHERE test.io_1;

Rows matched: 6  Changed: 5  Warnings: 0


SELECT * FROM test;


io_1
driver


1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065


CREATE TRIGGER trigger_name
BEFORE INSERT
ON test
FOR EACH ROW
SET NEW.driver = CASE WHEN NEW.io_1 = 0
                      THEN 0
                      ELSE ( SELECT MAX(driver)
                             FROM test )
                      END;
INSERT INTO test (io_1) VALUES (1), (0), (0), (1);
SELECT * FROM test;

Records: 4  Duplicates: 0  Warnings: 0




io_1
driver


1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

1
17EB0C401000065

0
0

0
0

1
17EB0C401000065

io_1	driver
1	17EB0C401000065
1	17EB0C401000065
1	17EB0C401000065
1	17EB0C401000065
1	17EB0C401000065
1	17EB0C401000065