Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Modifying data in a Sybase column

Tech Computer Center logo

If you have a rolodex file, and someone moves, you don't want to delete the information you have on them, then re-type all their information with the new address, you just want to change the address. Here's how to modify data in a table.

At the end of each command press the space-bar or press enter before continuing the next step.

  1. Type
            update
  2. Type the name of the table you are updating.
  3. Type
            set
  4. Type the name of the column that you want to change the data in.
  5. Type
            =
  6. Type the new value.
  7. Type
            where
  8. Type the name of the column you are changing the data in.
  9. Type your search conditions for finding the old data (see `Searching Sybase databases').
  10. Type
            go
    and press Enter.

If everything goes well, you see

        (1 row affected)
then the database prompt (a period, the name of the database you are using, another period, the number one and then the greater than symbol).

If you see

        Msg 207, Level 16, State 2
        Server '', Line 1
        Invalid column name 'name'.
you typed an invalid column name.

If you see

        (0 rows affected)
your search command didn't find any matching data to change.
See also: Adding and modifying data in Sybase
Previous: Inserting data in specific Sybase columns
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
Last updated: 1997/06/23 23:09:40 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/mod_col.html
QR two-dimensional bar code