mysql load data infile

Question

i got to execute loads of the following queries

UPDATE translations SET translation = (SELECT description FROM content WHERE id = 10) WHERE id = 1;

Now, i use the load data infile to do inserts and replacements but what i want in esense is to update just 1 field for each row in that table with out messing with the keys. What could be the syntax for this, note that the queries affect existing rows only.

Thanx

Jason S · Accepted Answer · 2010-12-09 16:16:11Z

6

Use CREATE TEMPORARY TABLE to create a temporary table.
Then use LOAD DATA INFILE to populate that temporary table.
Then execute your UPDATE translations SET translation = ... to set the 1 field from a SELECT of the temporary table, JOINed with the real table. example syntax below:
```
UPDATE realTable, tmpTable 
  SET realTable.price = tmpTable.price 
  WHERE realTable.key = tmpTable.key
```

answered Dec 9, 2010 at 16:16

Jason S

191k176 gold badges637 silver badges1k bronze badges

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

Collectives™ on Stack Overflow

mysql load data infile

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