ansaurus

Question

Answer 1

+5 A:

you run the statement:

UPDATE whateveryourtableis SET whateveryourcolumnis = 'whatever';

Dave Markle 2009-07-14 00:08:03

This is correct (+1), but be careful. Dave is answering your question specifically, but an UPDATE without a WHERE clause is not generally what you're looking for. :)

JP Alioto 2009-07-14 00:10:13

Beware, Russ, as this will overwrite any and all data in the column you update all at once. For large tables, this operation will consume lots of resources, too (disk/memory/log/etc.). I once did this to a table on a machine with low disk space...and there was not fun to be had. I'm talking about huge tables, though...100k-1m+ rows

Michael Haren 2009-07-14 00:10:49

Thanks for your help. That did it.

2009-07-14 00:12:25

Here's a double barrel shotgun, both barrels filled with double-aught buck and a hair trigger. Don't go shootin' yourself in the foot now...

Dave Markle 2009-07-14 00:19:28

Answer 2

+1 A:

Yes there is:

UPDATE [table]
SET [column] = 'Confirmed'

Jamie Ide 2009-07-14 00:09:28

Answer 3

+1 A:

Yould could make the desired value the new column's DEFAULT e.g.

ALTER TABLE MyTable ADD 
   my_new_column VARCHAR(20) DEFAULT 'Confirmed' NOT NULL;

onedaywhen 2009-07-14 00:12:41

ansaurus

tags:

views:

answers:

Fill entire SQL table column

related questions