insert with separate data

[sasori]

Hi, I got a problem here, need help 

 

I got  a country table it has

- country id

- country name

- country code

<!-- this is ok -->

 

I got states table it has

- state id

- country id  (empty)  :-\

- region id (empty )  :-\

- state name

- state code

<!-- this not ok -->

 

I got cities table and it has

- city id

- country code

- region code

- city name

<-- this is ok -->

 

now, what i want to happen is, fill in those empty field I indicated above that are empty , with their

corresponding data..the reason they were empty is that, I filled all these tables with datas

coming from chop-chopped chunks of text files .. can anyone help me ? 

 

[sasori]

never mind.. problem solved with

INSERT SELECT syntax ..hooray