How to add a column to the table:
create table table1 (id integer primary key, field1 text)
? The column would be field2 text and the value for existing rows in this column should be value.
views:
33answers:
2
+1
A:
That would be the SQL syntax:
ALTER TABLE table_name ADD column_name datatype
In your case, you'd be looking at:
alter table table1 add field2 text
update table1 set field2 = 'value'
paxdiablo
2009-05-31 04:31:45
+1
A:
For MySQL:
ALTER TABLE table1 ADD field2 text;
UPDATE table1 SET field2='value';
gahooa
2009-05-31 04:31:48
Why not to use: alter table table 1 add field2 text default 'value'
Bogdan Gusiev
2009-05-31 07:52:51
Because he did not specify that he always wanted the value to be 'value'. He just said "existing rows"...
gahooa
2009-06-01 18:57:48