How to add a line in sqlite if it is not there and change it if it is?

R

R

rogiivs2019-07-20 14:46:08

PHP

rogiivs, 2019-07-20 14:46:08

How to add a line in sqlite if it is not there and change it if it is?

I will describe the sequence of actions, there is a table, the `id` column is set to `primary key`, it is necessary that if the value of the `id` column already exists in the added row, then it is updated, and if it does not exist, then it is added. How to do it?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

longclaps, 2019-07-20
@rogiivs

UPSERT ( APSERT )

Similar questions

G

GRO242019-08-30 15:23:29

Why doesn't Bootstrap 4 align blocks? 2Reply

A

Andrey Filimonov2017-04-10 11:30:43

Why is there an indent between fields? 3Reply

S

student_it2015-04-19 11:49:55

How can I prevent the Referer from being sent when playing an audio file via the HTML Audio tag? 2Reply

V

VAZSOFT2019-09-28 20:55:53

Save POST request to TXT? 5Reply

P

podde2019-10-07 17:31:28

How to create an automatic signature in Service desk? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question