turn the first 2
rows from the table.
LIMIT 5, 10; would return rows 6 through 15 of the table.
Regards,
Tim
SQL, Query
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]]
Sent: 12 February 2002 23:20
To: [EMAIL PROTECTED]
Subject: Slow Database
Hello,
I'm writing
* Neil Tompkins
>
> Are there any settings I can set to limit the number of records returned ?
Yes, the LIMIT clause of the SELECT statement:
http://www.mysql.com/doc/S/E/SELECT.html >
--
Roger
query
-
Before posting, please
Hello,
I'm writing a application to connect to a mySQL database over a modem link.
Since the link is very slow, I need to limit the number of records returned
when the database and tables are opened. I connect to the database using a
ODBC driver.
Are there any settings I can set to limit the nu