K
K
kevus2018-06-21 21:43:01
MySQL
kevus, 2018-06-21 21:43:01

How to combine these three queries (SQL)?

How to combine these requests into one?

INSERT INTO db (name,link) VALUES ('%name%','%link%') ON DUPLICATE KEY UPDATE link = '%link%'
UPDATE db SET date = concat(date, '%date%|');
UPDATE db SET f = concat(f, '%price%|');

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Ruslan Fedoseev, 2018-06-21
@martin74ua

trigger on after insert

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question