|Frames||Modems||Help||Home Page||Chipsets||Search||No Frames|
|Diary Entries||See also Site Info & Diary.|
|24 November 2001||Adding columns to existing tables (ALTER)...|
|Realised that I needed a column within /mfc/ to flag a company that is now deceased:
ALTER TABLE /mfc/ ADD dead TINYINT AFTER UsesID;The manual (7.8) states that a temporary copy of the original table is made & changes made to this, then the original deleted & the copy renamed. The added column is filled with the default value (NULL here).