title: Insert into table concatenation of variables and constant tokens
body: <p>I have a table with the following schema</p>
  
  <pre><code>CREATE TABLE `foo` (
    `myfield` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>I've defined a couple of variables as follows</p>
  
  <pre><code>SET @NAME := 'Somename';
  SET @AGE := '31';
  </code></pre>
  
  <p>I need to insert into the table an entry composed of the concatenation of these user-defined variables and constant tokens. I've tried the following query</p>
  
  <pre><code>INSERT INTO `foo` (`myfield`) VALUES
  ('Name: ' + @NAME + ' Age: ' + @AGE);
  </code></pre>
  
  <p>The statement execution succeds, but after insertion <code>myfield</code> equals to:</p>
  
  <pre><code>31
  </code></pre>
  
  <p>It's just like the first part of the inserted value is ignored. What am I missing?</p>