Updateing DB

Results 1 to 2 of 2

Thread: Updateing DB

  1. #1
    Join Date
    Dec 1969

    Default Updateing DB

    Hi, I need help.<BR>How can I make the below code to update all the record that are equal to 1 to a 3<BR><BR>MySql = "Update * from Dates WHERE WeekNo = 1"<BR><BR>This works great if I want to Delete all the records where WeekNo=1, if I replace the word "Update" with "Delete". But that isn&#039;t want I need to do.<BR><BR>Help please.

  2. #2
    Eddie Campbell Guest

    Default RE: Updateing DB

    You need to tell Sql what to update:<BR><BR>MySql = "Update Dates Set Dates.Weekno=3 WHERE Dates.WeekNo = 1"<BR><BR><BR>

Posting Permissions

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