Christopher Kings-Lynne wrote:
>
> > *ALTER TABLE* isn't as easy as *CREATE TABLE*.
> > It has another problem because it hasn't implemented
> > *DEFAULT* yet.
>
> Just out of interest, is there a special reason it's difficult to implement
> the DEFAULT feature of alter table add column?
>
Without *DEFAULT* we don't have to touch the table file
at all. With *DEFAULT* we have to fill the new column
with the *DEFAULT* value for all existent rows.
regards,
Hiroshi Inoue