Alter Table Add field

[Ruslan Zasukhin]

on 12/9/03 1:53 PM, Tim James at tjames1 at bigpond.net.au wrote:

> I appreciate your comments about standards etc, but I think you may be
> mistaken, both in Valentina app and alter table statement it appears to
> insert column at the front of all existing columns (1.9.8)

Aha, I see what you mean. IF there was deleted column then yes,
New will be inserted

> (I find * is easier than 35 column names!!)

Yes, easier. But it is wrong and can cause problems.

> TIA
> On 09/12/2003, at 10:21 PM, Ruslan Zasukhin wrote:
> 
>> on 12/9/03 1:14 PM, Tim James at tjames1 at bigpond.net.au wrote:
>> 
>>> I know this has been mentioned some time ago, but has there been any
>>> change to
>>> 
>>> so that alter table add field adds the field
>>> at the END of the schema description so that any
>>> original select * statements don't have to be respecified
>> 
>> Hi Tim,
>> 
>> It adds column to the end.
>> And I think this will be always.
>> 
>> This is VERY NOT correct expect some order of fields in the SELECT *
>> !!!
>> 
>> This is written in all books and is true for each DBMS.
>> 
>> Never expect this.
>> 
>> IF you need some order, you MUST specify
>> 
>>         SEELCT f1, f2, ...

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------