MariaDB 10.3

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

create table `test_table` (id int);
create sequence `test_sequence`;
insert into `test_table` values(39)
SELECT @max_value := MAX(`Id`) FROM `test_table`;

@max_value := MAX(`Id`)

39

SELECT setval(`test_sequence`, @max_value, true);
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@max_value, true)' at line 1

SELECT @max_value;

@max_value

39