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