#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    15
    Rep Power
    0

    Delete just one cell and merge the rest together


    Hi,

    Iam trying to delete just one cell and merge the rest together.

    How it looks like:
    http://postimg.org/image/4p7fdjsy1/

    How it should like:
    http://postimg.org/image/ib8563akp/

    What I tried:
    PHP Code:
    DELETE
    FROM Test_Land
    WHERE salutation 
    "Deutsch" 
    this will delete the whole row, it shouldnt be like this.

    Maybe you can help me ...
  2. #2
  3. Did you steal it?
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,064
    Rep Power
    9398
    I'm not sure what you're trying to say with this "delete just one cell and merge the rest together" but I'm sure it's not possible.

    Fortunately it seems all you want to do is set the salutation to be "Herr".
    Code:
    UPDATE Test_Land SET salutation = "Herr" WHERE PID = 7;

IMN logo majestic logo threadwatch logo seochat tools logo