How to add a field to an existing database table?

[Jonathan]

Hi, I'm trying to make it possible to add a column/field to an
existing database table without transferring the information to a new
table (with the column added) altogether. Is there a simple MySQL
query I can use to do this?

[Pedro Graca]

Jonathan wrote:

Is there a simple MySQL query I can use to do this?

Yes. Check the documentation @
http://www.mysql.com/doc/en/ALTER_TABLE.html
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[Gordon Burditt]

>Hi, I'm trying to make it possible to add a column/field to an

existing database table
See ALTER TABLE.
without transferring the information to a new
table (with the column added) altogether.
Unfortunately, this is the way ALTER TABLE works. If you don't
have disk space for two copies of the table (briefly), it will
probably fail. Also, if you've got millions of rows, ALTER TABLE
can be slow. I'm not sure there is a faster alternative, though.
Is there a simple MySQL
query I can use to do this?

Gordon L. Burditt