www.webdeveloper.com
Results 1 to 3 of 3

Thread: Normalization of addresses

  1. #1
    Join Date
    Feb 2006
    Posts
    2

    Normalization of addresses

    Hello everyone.

    i've got this question?

    want to convert address in table A, address field, into address in table B, address field.

    Table A,field address, record 7 = via G.Garibaldi
    record 11 = via Garibaldi

    Table B field address, record 15 = via Giuseppe Garibaldi

    I have to modify record 7 and record 11 of Table A into via Giuseppe Garibaldi.

  2. #2
    Join Date
    Jul 2004
    Location
    West Coast, Canada
    Posts
    665
    Quote Originally Posted by nonmiviene
    Hello everyone.

    i've got this question?

    want to convert address in table A, address field, into address in table B, address field.

    Table A,field address, record 7 = via G.Garibaldi
    record 11 = via Garibaldi

    Table B field address, record 15 = via Giuseppe Garibaldi

    I have to modify record 7 and record 11 of Table A into via Giuseppe Garibaldi.
    What are you running? MySQL? Oracle?

    Try this:

    Code:
    sql> update tableA set fieldAddress = 'via Giuseppe Garibaldi' where recID = 7 and recID = 11;

    "Everything in a web browser."

  3. #3
    Join Date
    Feb 2006
    Posts
    2
    thanks but is not the way.

    Think of a table with these 3 fields (tAB A)

    name gender address

    record 1: paul - m - john wayne street
    record 25: peter - m - j.wayne st.
    record 39: bill - m - st.j.wayne

    AND tABLE B

    record x, field address : j. wayne street (the right structure)

    i have to create a new table in which record 1, table A, address field, become paul - m - "j. wayne street" (as written in table b);
    record 25,table A, become : peter - m - "j. wayne street", etc.etc.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles