What's wrong with the following query? The application used to use Access via
ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC 3.51.01.
// Return last 20 searches
SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname
FROM history h
INNER JOIN servers s
Yeah, put LIMIT 20 on the end.
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:12 PM
Subject: SELECT TOP
What's wrong with the following query? The application used to use Access
via
ODBC, now running MySQL 3.23.xx, MyISAM
wrote:
What's wrong with the following query? The application used to use Access via
ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC 3.51.01.
// Return last 20 searches
SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname
FROM history h
INNER JOIN servers
, and Performance Parts.
On Mon, 14 Jul 2003, Phil Bitis wrote:
Yeah, put LIMIT 20 on the end.
- Original Message -
From: Jim McAtee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:12 PM
Subject: SELECT TOP
What's wrong with the following query? The application
On Mon, 2003-07-14 at 17:44, Jake Johnson wrote:
Be careful! Phil wanted the top 20 and the limit 20 will only return a
random 20 records.
Actually, LIMIT x will return the first x rows of a query, not random
records. In fact, you can even combine ORDER BY and LIMIT if you want
to get the
What's wrong with the following query? The application used to use
Access via ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via
MyODBC 3.51.01.
// Return last 20 searches
SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname FROM
history h
INNER JOIN servers s
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:12 PM
Subject: SELECT TOP
What's wrong with the following query? The application used to use Access
via
ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC
3.51.01.
// Return last 20 searches
No kidding. I didn't know that. Thanks a lot!
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Mon, 14 Jul 2003,
Jake Johnson wrote:
No kidding. I didn't know that. Thanks a lot!
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On
Hi all-
I am really new to the list and mysql. Here is my Question.
I am used to writing SELECT TOP [num] FROM [table]
I have searched the documentation online and found no mention of how to do
this. But I did find info on LIMIT that limits the number of records
returned. Is this how mysql
On Fri, 11 May 2001, Anthony Colli wrote:
Hi all-
I am really new to the list and mysql. Here is my Question.
I am used to writing SELECT TOP [num] FROM [table]
I have searched the documentation online and found no mention of how to do
this. But I did find info on LIMIT that limits
11 matches
Mail list logo