DELIMITER $$

CREATE
    TRIGGER `myDB`.`rmTrigger` AFTER UPDATE
    ON `myDB`.`rm`
    FOR EACH ROW BEGIN
    IF NOT(new.TLID <=> old.TLID) THEN
     BEGIN
      UPDATE rmNames SET rmname.TLID = (SELECT CONCAT(ulname,ufname) FROM users WHERE uid=new.TLID);
     END;
    END IF;
    END$$

DELIMITER ;

SELECT column_name  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE table_name = 'rm'  ORDER BY ordinal_position;