Question

Company XYZ has a new employee named John Anderson. His employee ID is XYZ1234. His email address will be ail-protection" class="__cf_email__" data-cfemail="4e24602f202a2b3c3d21200e36373460">[email protected] 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','[email protected]');

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.