title: Insert MySQL Query with use of concat
body: <p>Im trying to insert a query to my database using a name in a variable and also using a name in the values. So i want to make it in to 1 name.</p>
  
  <p>Here is an example</p>
  
  <pre><code>SET @name = "This is my";
  INSERT INTO mytable (id, name)
  VALUES (1, @name + "Test Query");
  </code></pre>
  
  <p>So, This query should then insert a row with id 1 and name "This is my Test Query" But it gives me an error. <strong>Truncated incorrect DOUBLE value: 'Test Query'</strong></p>