MySQL puts an automatic limit of 1000 on all select queries. Try adding
LIMIT 10, and perhaps then it will take a good long time like
you want.
Tom.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I don't think you can get a query which will return a row for each
missing result, because a query can only return data that's there, not
data that's missing. (although if you generated another table with all
the numbers 1 through 1,000,000 that would work).
Anyway, to get one result row per
If you have a reason not to use InnoDB tables (e.g., speed, licensing,
fulltext indexes), you can implement pretty good client-side rollback in
PHP. Just send all calls through a database class (insert(), update(),
delete()) and if a transaction flag is set then they store in a stack a
little