Mysql duplication error

Question

I've wrote a query like below in order to insert unique 'project_title' value in the table ('projects').

INSERT INTO projects (projects.project_title, projects.description) 
SELECT * FROM (SELECT 'a title', 'a description') AS tmp 
WHERE NOT EXISTS (SELECT projects.project_title FROM projects WHERE projects.project_title = 'a title') LIMIT 1

This works fine until a same entry for both project title and project description entered and the query will be like this:

INSERT INTO projects (projects.project_title, projects.description) 
SELECT * FROM (SELECT 'text', 'text') AS tmp 
WHERE NOT EXISTS (SELECT projects.project_title FROM projects WHERE projects.project_title = 'text') LIMIT 1

Now, I get this error:

[Err] 1060 - Duplicate column name 'text'

How to get rid of this duplication error?!

try giving alias to the columns ...SELECT * FROM (SELECT 'text' AS firstText, 'text' AS secondText) AS tmp .... — 1000111
– 1000111, Commented Aug 2, 2016 at 9:22

1000111 · Accepted Answer · 2016-08-02 10:00:13Z

1

Extracting the erroneous statement here:

SELECT 
 tmp.*
FROM 
(
    SELECT 'text', 'text'
) AS tmp;

This query will generate this error

[Err] 1060 - Duplicate column name 'text'

Because you didn't give any alias to columns.

Solution:

Give alias to the columns:

SELECT 
  tmp.*
FROM 
(
    SELECT 
      'text' AS firstText, 
      'text' AS secondText
) AS tmp;

answered Aug 2, 2016 at 10:00

1000111

13.5k2 gold badges32 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql duplication error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related