CODEWITHSUNDEEP
mysqlsql-update
Gogolana
Gogolana

Reputation: 7

Update values by another column in another table

I need a query to:

Copy from database player, table item_proto_0, column locale_name

Paste to database player, table item_proto, column locale_name

But:

Just paste if has the same colum vnum

I've tried:

UPDATE item_proto.locale_name 
SET item_proto_0.locale_name 
WHERE item_proto_0.vnum=item_proto.vnum

Upvotes: 0

Views: 321

Answers (3)

Amit Vikram
Amit Vikram

Reputation: 402

Please run this sql query this should do the needful

UPDATE item_proto
inner join item_proto_0 on item_proto.vnum = item_proto_0.vnum
SET item_proto.locale_name = item_proto_0.locale_name

Upvotes: 0

ethorn10
ethorn10

Reputation: 1899

This should work:

UPDATE item_proto AS ip
    INNER JOIN item_proto_0 ip0 ON ip.vnum = ip0.vnum
SET locale_name = ip0.locale_name

Upvotes: 0

Hamlet Hakobyan
Hamlet Hakobyan

Reputation: 33381

Try this:

UPDATE item_proto P1
    JOIN item_proto_0 P2
       ON P1.vnum = P2.vnum
SET P1.locale_name = P2.locale_name

Upvotes: 2

Related Questions