MySQL Row Update Command ??

[abelajohnb]

Hello.

I just added a new field to an existing (and large) table.

I need to enter a default value into this new field... in every row of the table.

I thought it was:

Code:

UPDATE table_name SET foo=bar

---

But that did not work.

What should it be??

Thanks.

[Anon]

I think the mistake is that it should be

SET foo='bar'

Try it.

Nilesh

[abelajohnb]

Yep, sure was.

What an ignorant error that was....

Thanks!
JbA