mysql senu irasu istrynimas.

Sveiki,

Turiu lentele su laukais laikas bei tekstas.

Tarkim lenteleje yra 100 irasu.

Kokia uzklausa daryti norint palikti 15 naujausiu irasu, o likusius istrinti?

Zinau, kad kazkaip su order by bei limit, bet niekaip nepavyksta.

Aciu.

DELETE FROM TABLE WHERE id NOT IN (SELECT id FROM TABLE LIMIT 0,15)

Gal taip? :)

DELETE FROM TABLE WHERE id NOT IN (SELECT id FROM TABLE LIMIT 0,15)

 

Gal taip? :)

Aciu, uz pasiulyma.

DELETE FROM paieskos WHERE tekstas NOT IN (SELECT laikas FROM paieskos ORDER BY laikas DESC LIMIT 0,15)

#1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

:|

$laikas = select laikas from paieskos order by laikas desc limit 15,1;
delete from paieskos where laikas < $laikas

Per du querius.

Arba taip gali pabandyt, bet nežinau ar veiks.

delete from paieskos where laikas < (select laikas from paieskos order by laikas desc limit 15,1)