[thelist] MYSQL - Add field to table with data for existing records

Pedro Arana pedro.arana.matus at gmail.com
Thu Oct 12 13:09:32 CDT 2006

the two statements (ALTER & UPDATE ) option is the best.

And there is not a ALTER UPDATE statement for MySQL



On 10/10/06, M. Seyon <evolt07 at delime.com> wrote:
> I know I can use the ALTER command to add the field, but not sure how to
> add the value.
> I also know I can do this with two statements - first ALTER then UPDATE but
> wondering if it can be done in one go.
> Thanks.
> -marc

"Un ejército de ciervos dirigido por un león es mucho más temible que
un ejército de leones mandado por un ciervo." -Plutarco

More information about the thelist mailing list