Различные вопросы по PHP и MySQL

# Eternal (12.03.2019 / 19:52)
ДоХтор, БД

DELETE FROM `activnost`
WHERE `id` IN (
SELECT `id` FROM `activnost`
ORDER BY `id` DESC
LIMIT 5
)

не пускает, пишет что #1235 - Эта версия MariaDB пока еще не поддерживае

DELETE FROM `table`
WHERE id NOT IN (
  SELECT id
  FROM (
    SELECT id
    FROM `table`
    ORDER BY id DESC
    LIMIT 42 -- keep this many records
  ) foo
);

delete from users where id < (select max(id) from users)

# kantry (12.03.2019 / 20:10)
Eternal, Вложить запрос с max(id)
delete from users where id < (select max(id) from users)

DELETE FROM `files`
WHERE id NOT IN (
  SELECT id
  FROM (
    SELECT id
    FROM `files`
    ORDER BY id DESC
    LIMIT 1
  ) foo
);

DELETE t1
    FROM table t1
    JOIN table t2 ON t2.id < t1.id

# kantry (12.03.2019 / 22:08)
ДоХтор, Версия mysql старая наверно.


Попробуй с джойном?
DELETE t1
FROM table t1
JOIN table t2 ON t2.id < t1.id

SELECT version();

+-----------+
| version() |
+-----------+
| 5.7.20    |
+-----------+

# kantry (12.03.2019 / 22:08)
ДоХтор, Версия mysql старая наверно.


Попробуй с джойном?
DELETE t1
FROM table t1
JOIN table t2 ON t2.id < t1.id

# ДоХтор (12.03.2019 / 23:17)
kantry, не, не работает такой запрос:
ERROR 1064