only use a mysql query which can be run 1000 times and only put new rows in table if the title,body changes
Posted on 2013-11-29
users have a title and body in their social networking website
Think of myspace for example where some users1 has not edited their title and body 2 years. So user1 title,body 2 years ago is the same as user1 title,body current.
I do not want many rows of user1 because user1 is unchanged.
I do not want to prune duplicate values.
id (int),profile_id (varchar), timestamp, title (varchar), body (varchar). If body,title is different save a new title,body
I want historical values so if values are different, insert do not update
Please use mysql query.
because I have another question of trigger and stored procedure and php
I want to test this one query in mysql workbench query editor.