Topic: Trinimas

Sveiki.

Turim 30 skaiciu, po tam tikro laiko 20 skaiciu tampa nereikalingi. Kaip tuos 20 skaiciu istrinti?

ID SKAICIUS
1          1
2          2
3          3

ir t.t.

Re: Trinimas

DELETE FROM lentele WHERE skaicius = 1

arba

DELETE FROM lentele WHERE skaicius <= 20