gk2468
03-25-2006, 12:31 AM
Recentrly inserted rows can be know by useing rowid
But how to find recentrly updated rows.
But how to find recentrly updated rows.
|
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. dbasupport.com
Copyright Internet.com Inc. All Rights Reserved. |