The last post in a SQL table

[asai]

Hi,

Is there a way you can define select to get the last post in a MySQL table?

[DarrylBurke]

What does your question have to do with Java?

db

[asai]

I found a command to do this:

SELECT * from Table order by ID desc limit 1

The command is used in a Java program.

In the same program I want to create lines in a temporary table. When I press a button all theese lines will be transferred to another permanent table, and the lines in the temporary table will be deleted.

Any suggestions how to do this from my Java program?

[mine0926]

I think you dont need two tables for that, you can add a field which will identify if that record is temporary or permanent. Like zero(0) as temporary and one(1) as permanent.

[asai]

Very good idea. I will try this.
Thanks.