Error Code: 1060. Duplicate column name
<p>I've been receiving <strong>Error Code: 1060. :</strong> </p>

<ul>
<li>Duplicate column name 'NULL'</li>
<li>Duplicate column name '2016-08-04 01:25:06'</li>
<li>Duplicate column name 'john'</li>
</ul>

<p>However, I need to insert some field with the same value, but SQL is denying and showing the above error. The error is probably sql can't select the same column name, in that case is there other way of writing the code? Below is my current code</p>

<pre><code>INSERT INTO test.testTable SELECT * 
FROM (SELECT NULL, 'hello', 'john', '2016-08-04 01:25:06', 'john'
, '2016-08-04 01:25:06', NULL, NULL) AS tmp
WHERE NOT EXISTS (SELECT * FROM test.testTable WHERE message= 'hello' AND created_by = 'john') LIMIT 1
</code></pre>

<p>My Column:</p>

<ul>
<li>(id, message, created_by, created_date, updated_by, updated_date, deleted_by, deleted_date)</li>
</ul>

<p>Please assist, thanks.</p>