I believe in your case, you want it the other way around. LAST_NAME; The script above will update information in PERSONS_TMP table using data from PERSONS table.JSON API is designed to minimize both the number of requests and the amount of data transmitted between clients and servers.This efficiency is achieved without compromising readability, flexibility, or discoverability.
The key words “MUST”, “MUST NOT”, “REQUIRED”, “SHALL”, “SHALL NOT”, “SHOULD”, “SHOULD NOT”, “RECOMMENDED”, “MAY”, and “OPTIONAL” in this document are to be interpreted as described in RFC 2119 [RFC2119].
Now that you have created the Products table, you are ready to insert data into the table by using the INSERT statement.
After the data is inserted, you will change the content of a row by using an UPDATE statement.
But we can group the updates according to the value being set, and then do one UPDATE statement per distinct value.
DEPARTMENT FROM PERSONS P, TEMP_ECOLAB_PERSONS TE WHERE P.