Thread: Sql
-
Sql
Recentrly inserted rows can be know by useing rowid
But how to find recentrly updated rows.
-
select * from "the table you updated"
=
-
Originally Posted by gk2468
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|