can Mysql replace row automatically if primary key for that row already exist at insertion time?

Question

I am building a web-scraper which pulls data from websites and store it in database table . Primary key of the table is {timestamp+websitename} . Where timestap taken from that website . This happen in every 30 mins .

There are two possiblities a) I pulled the same data gain b) The content got edited on that website but still primary key remain same since creation time (timestap of this post) and website name remain unchanged.

Now I don't want to check using PHP weather same primary key exist or not. I just want data to get pushed into the database without giving me integrity constrain error . I want to do it for efficiency . Is there a way to do it in Mysql ? .

In simple words if row with same primary key already exist simply replace it with the current without throwing integrity constrain at me .

Bob Fanger · Accepted Answer · 2011-10-16 06:32:35Z

2

Yes, with REPLACE INTO statements.

A nice summary and caveats are described here

answered Oct 16, 2011 at 6:32

Bob Fanger

30k7 gold badges68 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cetver · Accepted Answer · 2011-10-16 06:27:27Z

0

if you use simple insert, take a look: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

answered Oct 16, 2011 at 6:27

cetver

11.9k6 gold badges42 silver badges59 bronze badges

Collectives™ on Stack Overflow

can Mysql replace row automatically if primary key for that row already exist at insertion time?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related