I have a users table that has phone numbers in a column:
username | name | Telephone
---------------------------
Jd | JOHN | 5550055
AT | ART | 5550066
And there is an authorization table
id | pin
---------------------------
1 | 5434
2 |
How to select a phone from the users table and add all the received numbers to the passwords cell so that it ends up like this::
id | pin
---------------------------
1 | 5434
2 | 5550055
5550066
I can add rows, I can update them, but I can't write a query that selects from a column and adds to a cell