Update query does not replace with nothing ?

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

0
  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
     
    johnberman, Aug 27, 2017 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,832
    Likes Received:
    4,541
    Best Answers:
    123
    Trophy Points:
    665
    #2
    Can you show us the query string that gets sent to the database when it fails?
     
    sarahk, Aug 27, 2017 IP