fixed no of rows in table

[claire]

I have a table with 30 rows. The columns are datetime, Name and Text. When I enter new info into the table from a form I want the oldest entry to be deleted.

Is it possible to set up a query that automatically deletes the oldes entry?

The only way to find out what entry to delete is to
1)either find the entry with the lowest id-no (if I add an id column). How then do I write the delete statement?

or

2)find the oldes by datetime (the column is set by using NOW().How then do I write the delete statement?

Thanks!

[gyoung]

You don't say which database you're using, however...

SQL Server

delete from myTable
where myDateTime in (select min(myDateTime) from myTable)

MySQL

delete from myTable
order by myDateTime
limit 1

[claire]

Sorry, I use MySQL.

Tried your suggestion - but it doesn't work..

don't know why..

[claire]

I have a MySQLtable with 30 rows. The columns are Date, Name and Text. When I enter new info into the tablefrom a form I want the oldest entry to be deleted.

Is it possible to set up a query that automatically deletes the oldes entry?

(The Date column is set by using the NOW() function).

How then do I write the delete statement?

                   Thanks!