SQL Update

Results 1 to 2 of 2

Thread: SQL Update

  1. #1
    Mark Guest

    Default SQL Update

    i&#039;m having problems writing an update for this - an id has two ratings (B1, C4), i need to update the B1 to a B4.<BR>for example: <BR><BR> OLD <BR>id rate_code<BR>001 B1<BR>001 C4<BR>002 B5<BR>002 C3<BR><BR><BR><BR> NEW<BR>id rate_code<BR>001 B4<BR>001 C4<BR>002 B3<BR>003 C3<BR><BR><BR>i hope this makes some sense, thanks.

  2. #2
    Tim Snyder Guest

    Default RE: SQL Update

    UPDATE &#060;table&#062; SET rate_code =&#039;B4&#039; WHERE rate_code = B1

Posting Permissions

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