Populate a new databaserow

[Anon]

Hi

Could any1 help with this.
Im administrating a shopping site that is allready launched. We have many thousand registered members. It is all based on a mysql database. What i want to do now is to add an extra row into the member table to let the users input what country they are from (we are expanding 🙂 For now all the users are from the same country, what i would like to do is to populate this row with the same input on all the users. How can i do this??

Please help me

Thanks alot

Tom

[Anon]

ALTER TABLE your_table ADD COLUMN country VARCHAR(20);

UPDATE your_table SET country='USA';

That will add column and update everyone in the table to have their country set to USA

---John Holmes...

[Anon]

Thanks alot worked perfect 🙂

Tom