开发者

Efficient ways of tracking updates to the database row

Given the following two tables, what are some of the most efficient ways to track updates to a given entit开发者_运维百科y (Entity table) and its data (EntityData).

Entity {

EntityID: Num

EntityData: Blob

}

EntityData {

ID: Num

EntityID: Num

Prop: String

Value: String

Type: Num

}


You can use triggers.

http://dev.mysql.com/doc/refman/5.1/en/create-trigger.html

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜