Updating with SQL

1. Click in the query area, and enter a SQL update command.

2. For example:

          update element set atomic_mass = atomic_mass + 1 where atomic_mass > 3

          (Increment the atomic mass by one for elements with atomic mass greater than 3.)

3. The rows will be updated.

See Also:

Deleting a Row