In this example we insert a single row into the esql Sales Person table.Here is its table structure: Let’s assume we want to the city for every sales person to Ann Arbor.The UPDATE statement is capable of updating more than one row. All rows returned via the WHERE clause criteria are updated.
For instance, if a field is defined as CHAR(10) and you update the value ‘Kris’ into this column, then it will be padded with six spaces.
The general form to use is: contains the update values; we use joins to do the matching.
Let suppose that someone has accidentally updated all esql Sales Person. How can we easily repopulate this data without having to retype it in?
Knowing that esql Sales Person was originally populated by information from Sales we use knowledge to set up a query that pumps data from v Sales Person into esql Sales Person.
This is possible since the sales person’s full name is common to both tables.