How to concatenate a variable plus a message in the "Insert"?

Question

Concatenate a variable and a message in the insert? Example:

declare a int;
set a = 2;
insert into tb_usuario values ('a' + 'fez tal coisa');

Answer 1

Yes, have, you need to use a function for this, in case it is the CONCAT(). Then it would look something like this:

insert into tb_usuario values (concat('a', 'fez tal coisa'));

Although this case does not make much sense to do so, I hope you are using a field or variable there. Who knows want to do this:

insert into tb_usuario values (concat(a, 'fez tal coisa'));

I put in the Github for future reference.

This will insert 2fez alguma coisa.