Example Name: USStates.sql
Description: Generate a USStates table in your MySQL or SQL Server database
Language: ActionScript 1.0
Version: 1.0.0
Code:
CREATE TABLE Northwind.USStates
(StateID INT NOT NULL,
StateName VARCHAR(100) NULL,
StateAbbr VARCHAR(2) NULL,
StateRegion VARCHAR(7) NULL);
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(1, 'Alabama', 'AL', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(2, 'Alaska', 'AK', 'north');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(3, 'Arizona', 'AZ', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(4, 'Arkansas', 'AR', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(5, 'California', 'CA', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(6, 'Colorado', 'CO', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(7, 'Connecticut', 'CT', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(8, 'Delaware', 'DE', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(9, 'District of Columbia', 'DC', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(10, 'Florida', 'FL', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(11, 'Georgia', 'GA', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(12, 'Hawaii', 'HI', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(13, 'Idaho', 'ID', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(14, 'Illinois', 'IL', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(15, 'Indiana', 'IN', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(16, 'Iowa', 'IO', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(17, 'Kansas', 'KS', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(18, 'Kentucky', 'KY', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(19, 'Louisiana', 'LA', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(20, 'Maine', 'ME', 'north');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(21, 'Maryland', 'MD', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(22, 'Massachusetts', 'MA', 'north');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(23, 'Michigan', 'MI', 'north');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(24, 'Minnesota', 'MN', 'north');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(25, 'Mississippi', 'MS', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(26, 'Missouri', 'MO', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(27, 'Montana', 'MT', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(28, 'Nebraska', 'NE', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(29, 'Nevada', 'NV', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(30, 'New Hampshire', 'NH', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(31, 'New Jersey', 'NJ', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(32, 'New Mexico', 'NM', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(33, 'New York', 'NY', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(34, 'North Carolina', 'NC', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(35, 'North Dakota', 'ND', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(36, 'Ohio', 'OH', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(37, 'Oklahoma', 'OK', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(38, 'Oregon', 'OR', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(39, 'Pennsylvania', 'PA', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(40, 'Rhode Island', 'RI', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(41, 'South Carolina', 'SC', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(42, 'South Dakota', 'SD', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(43, 'Tennessee', 'TN', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(44, 'Texas', 'TX', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(45, 'Utah', 'UT', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(46, 'Vermont', 'VT', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(47, 'Virginia', 'VA', 'east');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(48, 'Washington', 'WA', 'west');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(49, 'West Virginia', 'WV', 'south');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(50, 'Wisconsin', 'WI', 'midwest');
INSERT INTO USStates (StateID, StateName, StateAbbr, StateRegion) VALUES(51, 'Wyoming', 'WY', 'west');
Download code text
Download chapter example files