List:Bugs« Previous MessageNext Message »
From:Tonu Samuel Date:April 8 2000 8:23am
Subject:Re: crash-me: LIMIT vs. TOP
View as plain text  
mattj@stripped wrote:
> 
> I noticed something in the currently posted crash-me results (at
> http://www.mysql.com/crash-me-get.htmy).
> 
> Under "Expression Limits", mySQL supports "SELECT with LIMIT", and SQL
> Server 7.0 does not.  However, it should be added that SQL Server does
> support *this* syntax:
> 
> SELECT TOP 200 mycolumn FROM mytable ...
> 
> [The crash-me page gives results from mySQL 3.23.12, and I don't yet have
> a newer version than that installed, but the change history
> (http://www.mysql.com/Manual_chapter/manual_News.html) doesn't mention
> support for TOP, so I figure I'm safe in pointing this out :-) ]
> 
> Also, I rarely write to this list, so let me take a second to thank
> everyone, especially the mySQL developers, for providing such outstanding
> support.  Although I don't currently use mySQL in my day job, I can
> justify the time I spend reading this list because of all the tips on
> database design, application design, and query optimization. Then at home
> I can use the mySQl-specific stuff.  Thanks!
> 
> -Matt Jensen
>  NewsBlip
>  Seattle
> 
> (NewsBlip runs on mySQL)
> 
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread33560@stripped
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-tonu=mysql.com@stripped>

-- 
+----------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                           |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonu@stripped        |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
|             /*/             \*\                Developers Team |
+----------------------------------------------------------------+
Thread
Re: crash-me: LIMIT vs. TOPTonu Samuel8 Apr