PQL Update

The PQL UPDATE Statement
The UPDATE statement is used to update existing records in a stable.

PQL UPDATE Syntax
Note: Notice the WHERE clause in the UPDATE syntax. The WHERE clause specifies which record or records that should be updated. If you omit the WHERE clause, all records will be updated!

PQL UPDATE Example
The "Ponies" stable:

Now we want to update the pony "MareDoWell, Mysterious" in the "Ponies" stable.

We use the following PQL statement:

The "Ponies" stable will now look like this:

PQL UPDATE Warning
Be careful when updating records. If we had omitted the WHERE clause in the example above, like this:

The "Ponies" stable would have looked like this: