+ Reply to Thread
Results 1 to 2 of 2

Thread: Empty colums

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

    Empty colums

    I have a client table which contains the all information about a client , but we face a problem : there are lots of email fields are null and we need to populate this empty columns with unique value , any idea how to do that ?

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    41
    You can insert the client`s id into the empty email field :
    Code:
    UPDATE TABLENAME SET EMAIL = ID WHERE EMAIL IS NULL
    This is how you will get a unique value inside each empty email field .

+ 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