copy data from one table to another table

Discussion in 'PHP' started by srini_r85, May 23, 2010.

  1. #1
    hi,
    i have two table location and marker.when ever data insert into location table means it automatically store marker table also .but i need only four fields from location (i.e)name,street,latitude and longitude.this must store name,address,lat and lng in marker table.

    how it possible.any body plz help me.

    thanks
     
    srini_r85, May 23, 2010 IP
  2. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #2
    update marker set column1 = (select columntotransfer from location where [condition]) where [condition];
     
    bartolay13, May 24, 2010 IP