From: Peter Brawley
Date: July 26 2005 2:05am
Subject: Re: How to select first 1000 records like MySQL Control Center 0.9?
List-Archive: http://lists.mysql.com/mysql/186918
Message-Id: <42E59A7A.2010306@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=======AVGMAIL-42E59A7B0CFF======="
--=======AVGMAIL-42E59A7B0CFF=======
Content-Type: multipart/alternative; boundary=------------070802000703050407040605
--------------070802000703050407040605
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Siegfried Heintze wrote:
>Some dialects of SQL have SELECT [FIRST|TOP 1000] clause for their SELECT
>syntax. I looked at the syntax for mysql and it does not appear to have this
>feature.
>Apparently, however, this is possible because the MySQL Control Center does
>this. How does it do it?
See
[LIMIT {[/|offset|/,] /|row_count|/ | /|row_count|/ OFFSET /|offset|/}]
at http://dev.mysql.com/doc/mysql/en/select.html
PB
Siegfried Heintze wrote:
>Some dialects of SQL have SELECT [FIRST|TOP 1000] clause for their SELECT
>syntax. I looked at the syntax for mysql and it does not appear to have this
>feature.
>
>Apparently, however, this is possible because the MySQL Control Center does
>this. How does it do it?
>
>Thanks,
>Siegfried
>
>
>
>
--------------070802000703050407040605
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Siegfried Heintze wrote:
>Some dialects of SQL have SELECT [FIRST|TOP 1000] clause for their SELECT
>syntax. I looked at the syntax for mysql and it does not appear to have this
>feature.
>Apparently, however, this is possible because the MySQL Control Center does
>this. How does it do it?
See
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
at http://dev.mysql.com/doc/mysql/en/select.html
PB
Siegfried Heintze wrote:
Some dialects of SQL have SELECT [FIRST|TOP 1000] clause for their SELECT
syntax. I looked at the syntax for mysql and it does not appear to have this
feature.
Apparently, however, this is possible because the MySQL Control Center does
this. How does it do it?
Thanks,
Siegfried
--------------070802000703050407040605--
--=======AVGMAIL-42E59A7B0CFF=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date: 7/22/2005
--=======AVGMAIL-42E59A7B0CFF=======--