Re: appending INT to a column name in a trigger

[Darren White]

hmm, I'll try but I'm not sure I can state anymore clearly than "how to add an INT into a VARCHAR, in an mySQL trigger".

I asked on the MS sqlServer forums and they suggest this:

declare @t varchar(20)
select @t = 'log_'

declare @i int
select @i = 1

declare @ti varchar(20)
select @ti = @t + convert(varchar(32),@i)

select @ti

Result;
log_1

I am assuming I can do the same in mySQL perhaps just with slightly different syntax?