Is it possible to update a primary key column value with cascading the update among all the foreign keys referencing it ? # edit 1: when i run followinq query select * from sys.foreign_keys where referenced_object_id=object_id('mytable'). Both tables have the same primary key data (topic_id). i need to update the data field (content table) with the text "disabled" but only where the content_type field (topics table) = the text "rvf" i can: select * from topics where content_type = "rvf";. Mysql returns the number of affected-rows based on the action it performs: if the new row is inserted, the number of affected-rows is 1. plus 1 if there is a duplicate in unique index or primary key. mysql insert on duplicate key update example. let’s take a look at an example of using the insert on duplicate key update to understand how.
For this you create a new table actiontrack and if update query is run then insert a new record in this table . and then fetch a record in this action table using action id desc. or. take a timestamp field in the table and if update query is run then also update the timestamp field. then fetch the latest new timestamp field. Note: be careful when updating records in a table! notice the where clause in the update statement. the where clause specifies which record(s) that should be updated. if you omit the where clause, all records in the table will be updated!. If you have an autoincrement pk, and a unique key on say an email address, and the 'on duplicate update' triggers based on the email address, note that the last_insert_id' will not be the autoincrement value of the updated row..
