Cancellare il record meno recente

[piero.mac]

DELETE FROM tabella order by data  LIMIT 1

Single-table syntax: 

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]