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