Advanced Search

Return to Snippet

Revision: 47412
at June 7, 2011 20:56 by erraja_07
Initial Code 
INSERT INTO table_cities (`city`, `state`)
  SELECT C.cityname, S.statename
FROM `table_city` C
LEFT JOIN `table_state` S ON C.stateid = S.stateid
WHERE C.`countryid` =254
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MYSQL Table Migrations

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, query

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL