How to UPDATE a database

Results 1 to 2 of 2

Thread: How to UPDATE a database

  1. #1
    Join Date
    Dec 1969

    Default How to UPDATE a database

    Hi! This is a very silly question, I know, but as a beginner in ASP and databases I just can´t get it to work with the update function. I have a database with one table named Users and it includes fifteen fields. I want to update one of these and I wonder how I should do it. Please send me all code from beginning to end.<BR><BR>Thanks in advance/Fredrik

  2. #2
    Nathan Pond Guest

    Default RE: How to UPDATE a database

    UPDATE Table Set column1 = &#039New column value&#039, column2 = 100 Where id = 3<BR><BR>Just use &#039Set&#039 and only set a value for the fields you want to change. If you don&#039t use the where clause, the column for every row will be updated with the nex data, so if you only want to update one line make sure you put a where clause in there to specify which line. In this case it is id.<BR><BR>Nathan

Posting Permissions

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