If row dont exist, insert instead of update

Question

UPDATE userpostratings SET rating = $rating WHERE postID = 8

If a there isnt a row in userpostratings with postID = 8 i wanna INSERT instead. Could this be done with sql or should I do it in php

Thanks

Tomek

possible duplicate: http://stackoverflow.com/questions/913841/mysql-conditional-insert — Yasser Souri, Jun 13 '11 at 19:53
possible duplicate of [How do I update if exists, insert if not (aka upsert or merge) in MySQL?](http://stackoverflow.com/questions/1218905/how-do-i-update-if-exists-insert-if-not-aka-upsert-or-merge-in-mysql) — ypercubeᵀᴹ, Jun 13 '11 at 19:57

score 4 · Answer 1 · edited May 23 '17 at 10:34

4

edited May 23 '17 at 10:34

Community

answered Jun 13 '11 at 19:51

Ethan Cabiac

score 2 · Accepted Answer · answered Jun 13 '11 at 19:53

2

If you have a UNIQUE index on postID, then you can do something like:

INSERT INTO userpostratings (rating, postID) VALUES ($rating, 8)
    ON DUPLICATE KEY UPDATE rating = $rating;

answered Jun 13 '11 at 19:53

Ted Hopp

True, it requires a unique index. That's why I wrote "If you have a UNIQUE index...". Can I assume that this was your revenge downvote? – Ted Hopp Jun 13 '11 at 20:23

score -1 · Answer 3 · answered Jun 13 '11 at 20:03

-1

here you go

> mysql_query("UPDATE mytable SET used=1
> WHERE id < 10"); printf ("Updated
> records: %d\n",
> mysql_affected_rows());

answered Jun 13 '11 at 20:03

Grumpy

This doesn't do anything like OP was asking about. – Ted Hopp Jun 13 '11 at 20:05
ow..is that so? if mysql_affected_rows()==0 then insert – Grumpy Jun 13 '11 at 20:08
You didn't explain that. Plus, this requires two statements where one will do. – Ted Hopp Jun 13 '11 at 20:27

3 Answers3