function addDepartment() {
  // prompt for info about the new department
  inquirer
    .prompt([
      {
        name: "department",
        type: "input",
        message: "Enter new department name"
      }
      // NEED TO FIGURE OUT HOW TO ADD ID
    ])
    .then(function (answer) {
      // when finished prompting, insert new depsrtment info into table
      connection.query(
        "INSERT INTO department(name) VALUES (?)",

        [answer.department],

        function (err) {
          if (err) throw err;
          console.log("Your new department has been entered");

          start();
        }
      );
    });
}
//   NOT WORKING WHEN ENTER NEW DEPARTMENT.  GET THIS ERROR:  Unknown column 'department' in 'field list'
NOT WORKING WHEN ENTER NEW DEPARTMENT.  GET THIS ERROR:  Unknown column 'department' in 'field list'
NOT WORKING WHEN ENTER NEW DEPARTMENT . GET THIS ERROR : Unknown column ' department ' in ' field list '
function addDepartment() {
  inquirer
    .prompt([
      {
        name: "department",
        type: "input",
        message: "Enter new department name"
      }
    ])
    .then(function (answer) {
      connection.query(
        "INSERT INTO department(name) VALUES (?)",
        [answer.department],
        function (err) {
          if (err) throw err;
          console.log("Your new department has been entered");
          start();
        }
      );
    });
}
function addDepartment ( ) { inquirer . prompt ( [ { name : "department" , type : "input" , message : "Enter new department name" } ] ) . then ( function ( answer ) { connection . query ( "INSERT INTO department(name) VALUES (?)" , [ answer . department ] , function ( err ) { if ( err ) throw err ; console . log ( "Your new department has been entered" ) ; start ( ) ; } ) ; } ) ; }
NOT WORKING WHEN ENTER NEW DEPARTMENT.
NOT WORKING WHEN ENTER NEW DEPARTMENT .
// prompt for info about the new department // NEED TO FIGURE OUT HOW TO ADD ID // when finished prompting, insert new depsrtment info into table