Thomas Zehetbauer wrote:
> Why do I have to use FOUR queries to accomplish the same result I can
> get from MySQL with only ONE query:
>
> alter table users add column $ColumnName text;
> alter table users alter column $ColumnName set default '';
> update users set t_shirt_size='' where $ColumnName is null;
> alter table users alter column $ColumnName set not null;
Wow, that's true!
On MySQL 4.0.16-nt is also possible write:
alter table T1
add CONSTRAINT FK_test foreign key (id)
REFERENCES T2 (id);
that doesn't complain. Unfortunately repeating
the command N times doesn't complain neither.
And the funny here is that FK are not yet supported !
No regards.
Gaetano Mendola