[sqlite] Updating a filed in table a with contents from table b

On 2016/01/24 10:15 PM, audio muze wrote: > I have a large table with ~350k records for which I'm in the process of > standardising data. 350k records is not exactly a "large" table, A table scan would complete in a couple of seconds on a normal system. 350 million rows are more substantial

[sqlite] Updating a filed in table a with contents from table b

anyone?

[sqlite] Updating a filed in table a with contents from table b

I have a large table with ~350k records for which I'm in the process of standardising data. The fields I'm most interested in standardising are albumartist, artist, performer and composer. I'm dealing with one at a time and the logic for each is the same. I'll state in advance that I'm a SQL