Is it possible to do bulk insert/update in php?

Question

MySQL

Relatively speaking, there is a table

user  | age
-----------
user1 | 20
user2 | 22

How to make a table like this with one query?

user  | age
-----------
user1 | 22
user2 | 23
user3 | 35

Or do you still have to do two queries for each of them - select to check for existence and insert / update to add / change?

Answer 1

INSERT ... ON DUPLICATE KEY UPDATE