Recentrly inserted rows can be know by useing rowid
But how to find recentrly updated rows.
Printable View
Recentrly inserted rows can be know by useing rowid
But how to find recentrly updated rows.
select * from "the table you updated"
=
No, rowid is not a reliable way to find recently inserted rows.Quote:
Originally Posted by gk2468
You need to add a timestamp column of some sort to your table.
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.