Database in bulk import data, there are two columns of values need to be isolated from other tables, I now have no idea, to ask for doubts

I now bulk to the database to guide the official data (SQL Insert), but there are three columns of data are posts, offices, large areas, the data given only to the value of the post, the value of the office can be found through the post value in the Post table, the value of the region can be found through the office of the value of the office. Now I have all the other data in, only the office and the region has no value, how can I batch update the values of these two columns?

Table of imported data:

Post table:

Office table:

I SQL is not very good, I hope sql big God can give out doubts, humbly ~

Database in bulk import data, there are two columns of values need to be isolated from other tables, I now have no idea, ask for doubts >> MySQL

The answer is quite clear:
HTTP://WWW.GOODPM.NET/POSTREPLY/MYSQL/1010000007437901/database in bulk import data There are two columns of values that need to be isolated from other tables. I have no idea to ask for doubts now. html

Database in bulk import data, there are two columns of values need to be isolated from other tables, I now have no idea, to ask for doubts