Members

Technology Zones

IBM Learning Center

Articles

Hosted By

MaximumASP

Info
Rated
Read 173,106 times
5 comments

Contents

Related Categories

SQL Commands - Modifying Records

James Crowley

Modifying Records

To modify one or more existing record, you use the UPDATE statement. To use this command, you state the table to update, the values you want fields to be changed to, and, what records to be changed. For example,

UPDATE Users SET UserName = 'James Smith', Password = 'NEWPASSWORD' WHERE UserID = 10

In this case, all records which had a UserID of 10 would have their UserName and Password fields changed to the values given. If you only want one record to be updated, you need to ensure that in the WHERE clause, you specify a condition that will only return one record. This would normally be a unique id/primary key field.

Note that you do not have to include all the fields for the record.

If you want to update more than one record, you simply change the condition specified in the WHERE clause. For example,

UPDATE Furniture SET Price = 10 WHERE ItemType = 'Cupboard'

would change the Price field to 10 for all records in the Furniture table where their ItemType field had was "Cupboard".

James first started writing tutorials on Visual Basic in 1999 whilst starting this website (then known as VB Web). Since then, the site has grown rapidly, and James has written numerous tutorials, articles and reviews on VB, PHP, ASP and C#. In October 2003, James formed the company Developer Fusion Ltd, which owns this website, and also offers various development services. In his spare time, he's a 3rd year undergraduate studying Computer Science in the UK. He's also a Visual Basic MVP.

Comments

Read Comments | Post Comment

  • Check for Failed SQL Query

    Posted by zible on 24 Jan 2007

    This seems simple, yet I can't find how you do this. I need to run a query in VB on a very simple database. There is the possibility that the query would be unsuccessfull, and if so I need to do ot...

  • Sql Info

    Posted by darshan on 25 Apr 2005

    you need to fire sql statement like this
    select idno, name, email, return from [table_name] where [your_condition]

    this will return record set lets say "rs" is object of recordset
    then you will n...

  • Another database issue

    Posted by Abzmoh2007 on 11 Mar 2004

    Basically am trying to search a database by getting an input from the users selection on a list.
    the list contains names of countries and when i click that search button, how can i get the result of...

  • Filling Table With Datagrid

    Posted by NightChillz on 23 Dec 2003

    hey, i see how i can fill a datagrid with data from an sql table, but i am having trouble figuring out how to do the exact opposite, take data from a datagrid and fill an sql table with it/overriding ...

  • update data

    Posted by tomoko on 26 Nov 2003

    hi,
    pls help as i'm new in asp. i'm developing the administrative part of a website for my project. i'm having trouble with the "updating data" part. for example, i have done the 'add staff' and "de...