I have a script that can get result from news websites and it will run every hour.
The php script will get the title and content. The things I want to store in MySQL are:
createTime (which is the time when I inserted the record)
As I will run the php script every hour I know there will be many cases where the same news will be found by the script.
How do I design a table that allows me to
INSERT the new records, while previously existing news items are skipped?