CODEWITHSUNDEEP
mysql
Vladimir Štus
Vladimir Štus

Reputation: 217

Mysql insert column from another table

Ok i want to copy column with records from one table to another from diffrent databases, I have same structure its only translation OF countries names. Whats the best way to do that, i try to dump sql file only with colums and then write query but it seems it not posible?

INSERT INTO wp_drzava (NazivRo)
SELECT NazivRo FROM drzava
WHERE drzava.ID = wp_drzava.ID

I try something like this

Upvotes: 0

Views: 891

Answers (1)

jhavrda
jhavrda

Reputation: 395

You should use UPDATE instead.

UPDATE wp_drzava JOIN drzava ON wp_drzava.ID = drzava.ID SET wp_drzava.NazivRo = drzava.NazivRo

Upvotes: 2

Related Questions