Click to See Complete Forum and Search --> : Sql


gk2468
03-25-2006, 12:31 AM
Recentrly inserted rows can be know by useing rowid
But how to find recentrly updated rows.

epsonC84
03-25-2006, 12:40 AM
select * from "the table you updated"

=

WilliamR
03-26-2006, 02:16 PM
Recentrly inserted rows can be know by useing rowid
But how to find recentrly updated rows.
No, rowid is not a reliable way to find recently inserted rows.

You need to add a timestamp column of some sort to your table.

slimdave
03-26-2006, 10:17 PM
Relational databases have no built-in concept of when a row was changed -- if you need to know it then you store it. as WR says.