mysql> source C:\Users\Julian\Desktop\WebApp\create.sql Query OK, 3 rows affected (0.20 sec) Query OK, 1 row affected (0.00 sec) Database changed Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.05 sec) Query OK, 0 rows affected (0.06 sec) mysql> source C:\Users\Julian\Desktop\WebApp\insert.sql Query OK, 1 row affected (0.01 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.03 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.02 sec) Query OK, 1 row affected, 1 warning (0.04 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.01 sec) Query OK, 1 row affected, 1 warning (0.02 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.03 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.01 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.02 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.04 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.01 sec) Query OK, 1 row affected, 1 warning (0.01 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.03 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected, 1 warning (0.00 sec) Query OK, 1 row affected (0.00 sec) mysql> source C:\Users\Julian\Desktop\WebApp\select.sql +--------+----------------+--------------------+----------------+--------------+--------------+ | userID | name | email | location | phone | fax | +--------+----------------+--------------------+----------------+--------------+--------------+ | 1 | Walter Kroncat | walter@croncat.net | Spaulding Hall | 111-222-3334 | 111-222-3333 | +--------+----------------+--------------------+----------------+--------------+--------------+ 1 row in set (0.00 sec) +-------------+---------------------+---------+---------------+ | equipmentID | equipmentType | inStock | location | +-------------+---------------------+---------+---------------+ | 1 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 1 | GIS Laptop | Y | GIS Equipment | | 1 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 1 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 1 | iPad Loaner | Y | Nesmith Hall | | 1 | LCD Loaner | Y | Nesmith Hall | | 2 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 2 | GIS Laptop | Y | GIS Equipment | | 2 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 2 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 2 | iPad Loaner | Y | Nesmith Hall | | 2 | LCD Loaner | Y | Nesmith Hall | | 3 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 3 | GIS Laptop | Y | GIS Equipment | | 3 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 3 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 3 | iPad Loaner | Y | Nesmith Hall | | 3 | LCD Loaner | Y | Nesmith Hall | | 4 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 4 | GIS Laptop | Y | GIS Equipment | | 4 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 4 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 4 | iPad Loaner | Y | Nesmith Hall | | 4 | LCD Loaner | Y | Nesmith Hall | | 5 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 5 | GIS Laptop | Y | GIS Equipment | | 5 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 5 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 5 | iPad Loaner | Y | Nesmith Hall | | 6 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 6 | GIS Laptop | Y | GIS Equipment | | 6 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 6 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 6 | iPad Loaner | Y | Nesmith Hall | | 7 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 7 | GIS Laptop | Y | GIS Equipment | | 7 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 7 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 7 | iPad Loaner | Y | Nesmith Hall | | 8 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 8 | GIS Laptop | Y | GIS Equipment | | 8 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 8 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 8 | iPad Loaner | Y | Nesmith Hall | | 9 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 9 | GIS Laptop | Y | GIS Equipment | | 9 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 9 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 9 | iPad Loaner | Y | Nesmith Hall | | 10 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 10 | GIS Laptop | Y | GIS Equipment | | 10 | GPS (UNH-Moiles) | Y | 4-H GPS Units | | 10 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 10 | iPad Loaner | Y | Nesmith Hall | | 11 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 11 | GIS Laptop | Y | GIS Equipment | | 11 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 11 | iPad Loaner | Y | Nesmith Hall | | 12 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 12 | GIS Laptop | Y | GIS Equipment | | 12 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 12 | iPad Loaner | Y | Nesmith Hall | | 13 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 13 | GIS Laptop | Y | GIS Equipment | | 13 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 13 | iPad Loaner | Y | Nesmith Hall | | 14 | 'GPS (Hillsborough) | Y | 4-H GPS Units | | 14 | GIS Laptop | Y | GIS Equipment | | 14 | GPS (UNH-Nesmith) | Y | GIS Equipment | | 14 | iPad Loaner | Y | Nesmith Hall | | 15 | GIS Laptop | Y | GIS Equipment | | 15 | iPad Loaner | Y | Nesmith Hall | +-------------+---------------------+---------+---------------+ 72 rows in set (0.00 sec) +---------------------+--------+-------------+-------------------+-------+--------------------------------+-------------------------+----------+------------+------------+ | requestDate | userID | equipmentID | equipmentType | event | eventDescription | equipDetails | quantity | startDate | endDate | +---------------------+--------+-------------+-------------------+-------+--------------------------------+-------------------------+----------+------------+------------+ | 2014-11-26 15:14:20 | 1 | 1 | GPS (UNH-Nesmith) | Party | There is a party, we need GPS. | Trust me. We'll need it | 14 | 2014-11-25 | 2014-11-26 | +---------------------+--------+-------------+-------------------+-------+--------------------------------+-------------------------+----------+------------+------------+ 1 row in set (0.05 sec) mysql> quit;