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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
