Insert MySQL Query with use of concat
<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>