3
Reply

Sql related

Vipin Tyagi

Vipin Tyagi

Feb 28, 2014
1k
0

    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.

    Khan Abrar Ahmed
    May 08, 2014
    0

    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..

    Naitik Jani
    April 10, 2014
    0

    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

    Vipin Tyagi
    February 28, 2014
    0