You are looking for the ALTER TABLE statement. Here's a link to the
manual page about it:
http://www.mysql.com/doc/en/ALTER_TABLE.html
Your command should be something like:
ALTER TABLE Custumer_data
ADD field14 tinyint DEFAULT 1,
ADD field15 tinyint DEFAULT 1,
ADD field16 enum('no', 'yes') DEFAULT 'no',
ADD field17 tinyint DEFAULT 1,
ADD field18 enum('no', 'yes') DEFAULT 'no';
Of course you will need to make the column types whatever you really
want them to be, along with the column names.
If you include the DEFAULT clause when creating a new column, MySQL
will automatically update the existing rows to contain the default
value.
On Sun, 31 Aug 2003 15:04:08 +0200, Ryan A spoke thusly about
NewbieALERT - Question/problem:
> Hi,
> Am pretty new to mysqls power so kindly excuse if some of the questions are
> very basic.
>
> I have a table Cusomer_Data with 13 fields, (for the sake of simplicity lets
> call the fields 1 to 13)
> I want add 5 more fields after the 13th one and add the default falues of
>
> 1,1,'no',1,'no'
> to all the old records as the table is already populated and I *dont* want
> to lose the data that is already in the table....
>
> Can you tell me how to do that (sql statement) or kindly point me to some
> resource where i can read up on it please?
>
> Will I need multiple statements or just one query?
>
> Thanks,
> -Ryan
>
>
>
> We will slaughter you all! - The Iraqi (Dis)information ministers site
> http://MrSahaf.com
---
Listserv only address.
Jeff Shapiro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
