[ale] SQL differences

[James Sumners]

Agreed. Thanks for finding and posting this.

Let me tell you, it is frustrating working with Oracle and MSSQL after
having used MySQL for so long. So many easy things in MySQL (e.g. the
LIMIT clause and the TIMESTAMP and AUTO INCREMENT column types) are
completely missing in the other two that I now have to use. I can see
this page being use very frequently by me.

On Thu, Oct 7, 2010 at 10:37 AM, Jim Kinney <jim.kinney at gmail.com> wrote:
> Excellent find! A cursory glance down the (long) page confirms my
> experience: postgresql track Oracle and MySQL tracks MSSQL but does a better
> job :-) .
>
> On Thu, Oct 7, 2010 at 10:26 AM, Chris Fowler <cfowler at outpostsentinel.com>
> wrote:
>>
>> I found this today while trying to figure out why 'limit 1' does not
>> work in SQL Server.
>>
>> http://troels.arvin.dk/db/rdbms/
>>
>> _______________________________________________
>> Ale mailing list
>> Ale at ale.org
>> http://mail.ale.org/mailman/listinfo/ale
>> See JOBS, ANNOUNCE and SCHOOLS lists at
>> http://mail.ale.org/mailman/listinfo
>
>
>
> --
> --
> James P. Kinney III
> I would rather stumble along in freedom than walk effortlessly in chains.
>
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>
>



-- 
James Sumners
http://james.roomfullofmirrors.com/

"All governments suffer a recurring problem: Power attracts
pathological personalities. It is not that power corrupts but that it
is magnetic to the corruptible. Such people have a tendency to become
drunk on violence, a condition to which they are quickly addicted."

Missionaria Protectiva, Text QIV (decto)
CH:D 59