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.

Update Table

Discussion in 'Databases' started by Šatra, Mar 21, 2020.

0
  1. #1
    Hi, how to update derived table with data from base table?
    From table titles where I insert new row, I need update table current_title.
    Current_title is table derived from table title where column to_date=9999-01-01.
    Untitled6.png
     
    Šatra, Mar 21, 2020 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,500
    Likes Received:
    4,460
    Best Answers:
    123
    Trophy Points:
    665
    #2
    If by derived table you mean a "view" - it happens automatically.
     
    sarahk, Mar 21, 2020 IP
  3. Šatra

    Šatra Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #3
    OK. I assumed it would happen, but I think in one case it was problem. I will check again. Thanks.
     
    Šatra, Mar 21, 2020 IP