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.

Respuesta :

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.

ACCESS MORE
EDU ACCESS
Universidad de Mexico