With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); Note that all data types use rather obvious input formats Language The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 6 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish

With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25, ’1994-11-27’); 7 Chapter 2. The SQL Language Note that all data types The point type requires a coordinate pair as input, as shown here: INSERT INTO cities VALUES (’San Francisco’, ’(-194.0, 53.0)’); The syntax used so far requires you to remember the order of the columns to list the columns explicitly: INSERT INTO weather (city, temp_lo, temp_hi, prcp, date) VALUES (’San Francisco’, 43, 57, 0.0, ’1994-11-29’); You can list the columns in a different order if you wish