sasori Posted October 15, 2010 Share Posted October 15, 2010 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 ? Quote Link to comment https://forums.phpfreaks.com/topic/215938-insert-with-separate-data/ Share on other sites More sharing options...
sasori Posted October 15, 2010 Author Share Posted October 15, 2010 never mind.. problem solved with INSERT SELECT syntax ..hooray Quote Link to comment https://forums.phpfreaks.com/topic/215938-insert-with-separate-data/#findComment-1122472 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.