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

Modifying data in a Sybase column

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.

Type
```
        update
```
Type the name of the table you are updating.
Type
```
        set
```
Type the name of the column that you want to change the data in.
Type
```
        =
```
Type the new value.
Type
```
        where
```
Type the name of the column you are changing the data in.
Type your search conditions for finding the old data (see `Searching Sybase databases').
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 Computer Center: Help System
TCC 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