what's the syntax to update a column on table from a COUNT(*)
539442Nov 27 2006 — edited Nov 27 2006what's the syntax to update a column on table from a COUNT(*):
Something like this is posible?
UPDATE TEMP_PESQUISA_DIGITAL
SET total = SELECT COUNT(*) FROM TEMP_PESQUISA_DIGITAL;