Updating a table's information...

[Anon]

I am a bit of a SQL beginner so I need a little help with this problem. I have looked over mysql.com and other sites and all I find in 'general' help (ie. no examples).

From the command line (in mysql), I want to select certain data from a table and replace its current value with a new one.

Table: customer

id: 1

LockedAcct: N

For testing purposes I want to change the 'N' value to a 'Y'. How do I go about doing that?

-- M

[Anon]

update customer set LockedAcct = 'Y'
where id = 1

[Anon]

Thanks. Thats what I was looking for =)