3
Reply

Sql related

Vipin Tyagi

Vipin Tyagi

10y
1k
0
Reply

    Hi, you can use the seperator to insert the address as string. or create a new table with refrence of person id and store the address on this table.

    You can do that by one way..Person which have 3 addresses you can store that address into Address column only with some special kind of separator "|]|" Address1|]|Address2|]|Address3 and for all other records only Address1 and with help of separator you can identify the same. for your easiness.Hope this can help you..

    if there are some column in a table 

    one column is for address 
    there are 50 people in table 
    we want to store 3 address for a person and other 49 have only single address 
    how we write the query