Your 3 DREAM FEATURE for Vstudio ?

[Ruslan Zasukhin]

On 6/21/05 12:40 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:

Hi Heinrich, 

> id INTEGER NOT NULL DEFAULT 0, -> not working
> id INTEGER DEFAULT 0 NOT NULL,  -> is working

Standard SQL92 says:

<column definition> ::=
     <column name> { <data type> | <domain name> }
     [ <default clause> ]
     [ <column constraint definition>... ]
     [ <collate clause> ]

I.e. Default clause STRICTLY go before constraints.


So, question is: 
    your first query -- is YOUR attempt?
    or this is generated by mySQL ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]