Concat trigger separators

[poodleinplad]

I'm trying to create a trigger that concates several columns into one but something is wrong with "the separators". Trigger example:

DELIMITER $$
CREATE TRIGGER combine_path
BEFORE INSERT ON  table_x
  FOR EACH ROW
    BEGIN
       SET NEW.comb_path = CONCAT(NEW.valueone, '_', NEW.valuetwo, '_', NEW.valuethree);
END
$$
DELIMITER ;

 

I want the results to be 1_2_3 but with this trigger I only get 1 unless I remove the underscore. What am I doing wrong?

[mikosiko]

read .... http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat

[poodleinplad]

Thanks, I finally got it. I think I was somewhat stupid. The target column was "INT" so I guess it didn't want an underscore!

Anyhow, this is the trigger that finally did it.

DELIMITER $$
CREATE TRIGGER combine_path
BEFORE INSERT ON  table_x
  FOR EACH ROW
    BEGIN
       SET NEW.comb_path = CONCAT_WS('_',NEW.valueone,NEW.valuetwo,NEW.valuethree);
END
$$
DELIMITER ;