Question: what is the difference between update and modify in sql?
Answer: The MODIFY statement inserts one or several lines specified in source in the database table specified in target, or overwrites existing lines. The statement UPDATE changes the content of one or more lines of the database table specified in target.