[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
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html


Saludos

    Pedro

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