Replace if exists or insert in mySQL database from Python

Question

I would like to replace a value if the date/time for a row in table is the same for the one he try to insert. If the time/date doesn't exist in the table then insert it.

If you se the picture. The value nr 2 to the end has the same time as the first value. Then it should replace the first one because they have the same time. Not get added last to the list. If the time doesn't exist, then it can be added.

I have tried with REPLACE and ON DUPLICATE KEY UPDATE, but I cant get it to work...

"INSERT INTO flowAvarageValuesDays (time, value) VALUES (%s, %s) ON DUPLICATE KEY UPDATE avarageFlowValueDays=%s", (time,value,value)

and

"REPLACE INTO flowAvarageValuesDays (time, value) VALUES (%s, %s)",
            (time, value)

Table

I cant get it to work... is not very helpful. Post code minimal reproducible example and the full traceback you get — buran
– buran, Commented Mar 10, 2020 at 18:17
@PederWard: look at this: stackoverflow.com/a/19950545/42346 — mechanical_meat
– mechanical_meat, Commented Mar 10, 2020 at 18:27
You can add condition for your query if(time = (SELECT time FROM table WHERE %s IN (time),INSERT,UPDATE) If time doesn't exist then it will insert else update — SE.Edward
– SE.Edward, Commented Mar 11, 2020 at 0:16

SE.Edward · Accepted Answer · 2020-03-11 00:23:36Z

1

IF(SELECT time FROM table WHERE %s IN(time), INSERT INTO flowAvarageValuesDays (time, value) VALUES (%s, %s) ON DUPLICATE KEY UPDATE avarageFlowValueDays=%s, (time,value),REPLACE INTO flowAvarageValuesDays (time, value) VALUES (%s, %s),

(time, value))

answered Mar 11, 2020 at 0:23

SE.Edward

2013 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Replace if exists or insert in mySQL database from Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related