Question

Company XYZ has a new employee named John Anderson. His employee ID is XYZ1234. His email address will be j.anderson@xyz. His information will need to be added to the Employee database. Write an SQL statement to add his information into the Employee table.

Answer 1

Answer:

INSERT INTO Employee(employeeName,employeeID,employeeEmail)

VALUES('John Anderson','XYZ1234','j.anderson@xyz');

Explanation:

First write the statement INSERT INTO then write table name which in our case was Employee. Inside the round brackets add column names say employeeName,employeeID,employeeEmail , then write VALUES and add your values of columns you added respectively.

Make sure to write exact same column names you have in your table.