MYSQL. Золотой фонд запросов.
2018.10.15 12:24
1. Как найти первый незанятый идентификатор:
SELECT (mytable.id+1) as new_id FROM mytable WHERE (SELECT 1 FROM mytable as st WHERE st.id=(mytable.id+1)) IS NULL ORDER BY mytable.id LIMIT 1
то же, но начиная с 1000
SELECT (mytable.id+1) as new_id FROM mytable WHERE mytable.id>1000 AND (SELECT 1 FROM mytable as st WHERE st.id=(mytable.id+1)) IS NULL ORDER BY mytable.id LIMIT 1
2. (SELECT * ORDER BY `f1` DESC LIMIT 15) ORDER BY `f2` DESC;
КОММЕНТАРИИ
Введите код с картинки: