-1

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

0 Answers0