InterviewSolution
Saved Bookmarks
| 1. |
How will you update the rows that are already exported? |
|
Answer» The parameter --update-key can be used to update existing rows. In it a comma-separated list of columns is used which uniquely identifies a row. All of these columns is used in the WHERE clause of the generated UPDATE query. All other table columns will be used in the SET part of the query. |
|