Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    19

    Unanswered: A SQL SELECT Statement for updating data in a table

    Hi

    What would the SQL statement be for:

    In table “tblNames” on row ID “25” update the users name under the field “Name” to (bla bla bla) and update the job title under the filed “Job Title” to (blab la bla)

    Thanks

  2. #2
    Join Date
    Jan 2006
    Location
    New England
    Posts
    12
    UPDATE tblNames SET Name = "bla bla bla", JobTitle = "blab la bla"
    WHERE rowID = 25;

Posting Permissions

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