Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

I need to add the Count into the message text

I need to add the Count into the message text. How can I correct the code?

delimiter $$
Create trigger passengercount after insert on passenger
For Each Row
Begin
declare @count int
set @count=10
SET @count = @count + 1
SET MESSAGE_TEXT = 'You have' @count 'Passengers'
END; $$
delimiter ;

Comments