Inserting rows to a table from another SELECT - MySQL

Question

I have a table called CountriesList with ID and Country columns.
I have another table called Entries which have a column named Country.

I would like to INSERT all the countries in Entries into CountriesList... I am using the following syntax:

INSERT INTO CountriesList ('Country') 
SELECT DISTINCT ('Country')
FROM  `Entries`

However, I get

1064 - You have an error in your SQL syntax

What is wrong with the syntax?

random · Accepted Answer · 2012-04-05 03:22:12Z

4

Don't mix up single quotes (') and backticks (`).

Backticks are for database and column names.

Single quotes are used for strings.

INSERT INTO `CountriesList`
(`Country`) 
SELECT DISTINCT `Country` FROM `Entries`

edited Apr 5, 2012 at 3:22

random

9,97810 gold badges71 silver badges85 bronze badges

answered Mar 1, 2011 at 9:44

Dominik Kukacka

5651 gold badge5 silver badges15 bronze badges

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

Comments

sureshchand · Accepted Answer · 2014-01-06 10:03:06Z

2

Insert into entries(country) 

     select distinct(country) from 

    countrylist where country not in

     (select country from entries)

answered Jan 6, 2014 at 10:03

sureshchand

512 bronze badges

Comments

Sachin Shanbhag · Accepted Answer · 2011-03-01 09:41:40Z

0

It should be -

INSERT INTO CountriesList
(Country) 
SELECT DISTINCT Country FROM  Entries

answered Mar 1, 2011 at 9:41

Sachin Shanbhag

55.8k11 gold badges92 silver badges103 bronze badges

Comments

Deepak · Accepted Answer · 2011-03-01 09:44:47Z

0

try this insert into Entries (country) select country from CountriesList

answered Mar 1, 2011 at 9:44

Deepak

8,0173 gold badges26 silver badges26 bronze badges

Collectives™ on Stack Overflow

Inserting rows to a table from another SELECT - MySQL

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related