Topic: Optimization INSERT INTO at introduction of the data with repeating records
Beforehand , could not find the clear answer to the question.
Let's assume, there are two cities, in them certain departments of one company are allocated. This information is necessary for importing to a DB.
It is possible to produce some operations on adding of a city with a binding to id department
...(' St. Petersburg ', 1),
(' St. Petersburg, 2 '),
But that that prompts to me what probably to import the binding information a city-id as that more optimally, one iteration.
Respected , whether there is such possibility?