On 11/3/05, Lewis Sellers [EMAIL PROTECTED] wrote:
A. SELECT TOP 50 doesn't work in mySQL. Top is
only SQL
Server, correct?
B. From Shows Limit 50 returns an error as well.
To further elaborate on your question...
Question: Is it Shows or shows? Case makes a difference (between
Les,
1. What's the equal of TOP in mySQL?
LIMIT is the correct syntax, but you just had it in the place:
SELECT * FROM myTable ORDER BY myField LIMIT 10
2. At what point in the query is that actually evaluated?
Right at the end, after any WHERE/ORDER statements etc.
HTH,
Tim.
--
statement to me was to try to hit me up for a
spare copy of tcpclient or something :-P
--min
-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 3:13 PM
To: CF-Talk
Subject: Re: Limit or Top and mySQL Question
I believe you've
I believe you've answered yourself in your subject. It's called LIMIT
in mysql, and it's slightly more flexible than using TOP.
SELECT Airdates.ShowID FROM shows LIMIT 30;
shows only the first 30 records returned from the query.
SELECT Airdates.ShowID FROM shows LIMIT 10,30;
shows records
I thought you were dead!!! ;)
-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 3:13 PM
To: CF-Talk
Subject: Re: Limit or Top and mySQL Question
I believe you've answered yourself in your subject. It's called LIMIT
in mysql, and it's
A. SELECT TOP 50 doesn't work in mySQL. Top is
only SQL
Server, correct?
B. From Shows Limit 50 returns an error as well.
To further elaborate on your question...
Question: Is it Shows or shows? Case makes a difference (between
platforms). As a general rule it's best to have all
6 matches
Mail list logo