1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Can we insert data into two or more than two tables using one INSERT query ???

Discussion in 'MySQL' started by jimmy4feb, Nov 17, 2010.

  1. #1
    Hello DP members,

    I am wondering if someone can help me with an example for the question I asking...

    Thanks,

    Jimmy
     
    jimmy4feb, Nov 17, 2010 IP
  2. imocoder

    imocoder Member

    Messages:
    45
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    43
    #2
    You cannot insert into multiple tables using one query.
     
    imocoder, Nov 19, 2010 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    jestep, Nov 19, 2010 IP
  4. teamaguilar

    teamaguilar Peon

    Messages:
    197
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    It is not possible to insert data into two tables in a single query
     
    teamaguilar, Nov 23, 2010 IP
  5. senth

    senth Peon

    Messages:
    53
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I never heard about inserting into two different tables using single INSERT statement, may be in future versions.
     
    senth, Nov 24, 2010 IP