You can update as many fields as you want by separating each with a comma, as in the following:
UPDATE PRODUCTION
SET CUSTOMER TO NULL, SLIPID TO NULL, STATUS=0
WHERE SLIPID="17753"
There are also commands to insert new records and remove records. This is a basic introduction to SQL. There are many more features that haven’t been discussed, including joining tables by selecting from more than one table, embedding select statements, searching for partial matches, etc. If you are interested, consult a book on SQL.
|