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