+ Reply to Thread
Results 1 to 3 of 3

Thread: Update column issue

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    6

    Update column issue

    Hi , i am trying to update a certain column
    My table desin is like :
    Code:
     ID (int) 
     Group ID  (int)
     Details   (varchar)
    So far i tried :
    Code:
     UPDATE table
     SET GroupID = 3
     WHERE GroupID = 1
    Buy failed and i tried the next :
    Code:
     SELECT REPLACE(Group_ID, "1", "3")
     FROM table
    But also failed ......

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    45
    Maybe because your Group ID has space , try this :
    Code:
    UPDATE SystemSpecCategories
    SET [Group ID] = 9
    WHERE [Group ID] = 8

  3. #3
    Junior Member
    Join Date
    Jan 2012
    Posts
    6
    Oh it worked indeed , i better alter the name to GroupID , thanks

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts