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 query does not replace with nothing ?

Discussion in 'MySQL' started by johnberman, Aug 27, 2017.

  1. #1
    This query works fine
    [SQL]UPDATE duration_events b
    JOIN meteor_events p
    ON p.event_id = b.event_id
    SET b.eventdes = p.eventdes;

    so if enter some text in meteor_events, eventdes for a particular record then the text in the corresponding record in duration_events get updated.

    How ever if I then remove the text from meteor_events, eventdes and run the query its not replaced in duration_events - i had assumed it would simple repace the contents of the field ?

    John B
    SEMrush
     
    johnberman, Aug 27, 2017 IP
    SEMrush
  2. sarahk

    sarahk iTamer Staff

    Messages:
    24,043
    Likes Received:
    3,239
    Best Answers:
    92
    Trophy Points:
    615
    #2
    Can you show us the query string that gets sent to the database when it fails?
     
    sarahk, Aug 27, 2017 IP