Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

podmaster (3169)

podmaster
  (email not shown publicly)

I am podmaster.
I praise pod.
I praise well written pod.
I praise [Pod::Usage].
I also praise the [TheLarry] and [TheDamian], and to a certain extent, [merlyn] (i mean RandalL), for his beer drinking abilities

Journal of podmaster (3169)

Tuesday December 24, 2002
09:40 PM

MYSQL DOCUMENTATION ON SELECT SYNTAXT IS FALSE

[ #9620 ]
update: It's been a little while, and I don't recall where I got the idea that LIMIT 1 LIMIT 2 is valid syntaxt, but it's not. I'll chalk this up to sleeplesness.

Try

SELECT * FROM sometable LIMIT 1 LIMIT 2;

That's supposed to be legal in mysql, as well as it's own custom equivalent

SELECT * FROM sometable LIMIT 2,1;

but mysql BARFS on the first one as illegal syntaxt.

I can't believe my eyes (got mysql4 alpha, and mysql3.2 something).

I'm getting 4.0 Gamma right now to try it there.