You want to use an UPSERT SELECT.
UPSERT INTO mytable (primary_key_col, PULL_DATE) SELECT
primary_key_col, CURRENT_DATE() FROM mytable;
James
On 10/09/15 20:40, M. Aaron Bossert wrote:
> I have a table that requires an additional column with the current
> date added. I realize that I can't do this using the CSV
> importer...How can I do that in a query? I tried standard SQL with
> UPSERT instead of INSERT:
>
> UPSERT INTO NG.BARS_CNC_DETAILS_HIST SET PULL_DATE=CURRENT_DATE();
>
>
> but this gives a syntax error.
>
|