Your 3 DREAM FEATURE for Vstudio ?

[Heinrich Ruoff]

the first query was generated by a xml parser for mySQL
but I can try to change the order by a regular search&replace expression

what about default strings - how do they work?
myText text(512) DEFAULT 'default string'
didn't work


On 6/21/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> 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]
> 
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>