Chuck,
I have database that has grown in size, I want to see what ID files have
been deleted. Is there a way or do I have to print out the list and find
them myself?
Assuming by files you mean rows, and assuming a table named t1, a column
in it named id, and you having done something like ...
SELECT @idmax := MAX( id ) FROM t1;
then this gives you missing numbers:
SELECT t1.id
FROM t1 LEFT JOIN t1 AS t2
ON t1.id = t2.id-1
WHERE t2.id IS NULL AND t1.id @idmax;
Once MySQL gives us subqueries in 4.1 (December?), it'll be easier ...
SELECT id AS id1 from t1
WHERE id idmax AND
NOT EXISTS (SELECT id FROM t1 WHERE id = id1 - 1);
HTH
PB
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
