Batch update?

[howachen@gmail.com]

Consider two tables:

Table_1 (id, data_1, data_2)

Table_2 (id, data_2)


How to load the `data_2` field from Table_2 to Table_1, which is linked
by `id`?

Thanks.

[Captain Paralytic]

[email]howachen@gmail.com[/email] wrote:

> Consider two tables:
>
> Table_1 (id, data_1, data_2)
>
> Table_2 (id, data_2)
>
>
> How to load the `data_2` field from Table_2 to Table_1, which is linked
> by `id`?
>
> Thanks.

update Table_1,Table_2
set Table_1.data_2 = Table_2.data_2
where Table_1.id=Table_2.id