athena — 2005-07-26T15:55:08-04:00 — #1
I'm familiar with how you do most database stuff within MySQL, however I'm running into some problems as I try to take that SQL knowledge over to MS Jet SQL for Access 2000.
If I were to write the query under MySQL it would be
"SELECT * FROM
Anim LIMIT 0, 30"
But if I were to send that query to an Access database, I get an error. Does Jet SQL not have a Limit command? If not, is there some other way to get the same functionality?
r937 — 2005-07-26T16:09:56-04:00 — #2
that's right, jet sql is not the same as mysql sql
select top 30 * from [Anim] order by foo
note that neither LIMIT nor TOP makes sense without an ORDER BY, since the order of rows within a table is not defined
athena — 2005-07-26T17:30:16-04:00 — #3
Actually I am a little surprised given that I understood that MySQL was just SQL with a bit of handy admin stuff stuck on top... but anyways...
What about if I want to select 30 records starting at record 60?
MySQL code: "SELECT * FROM
Anim LIMIT 60, 30"
r937 — 2005-07-26T18:10:11-04:00 — #4
that's actually a lot harder than you might think