You work as a Database Administrator for Domain.com. The company uses MySQL as its
database.
You have created a new table named Employees, which keeps all the information of the
employees. You want to add a new row to the Employees table. Which of the following statements
will you use to accomplish the task?
A.
INSERT (column1, column2, …columnN) INTO <table_name> VALUES(value1, value2, …v
alueN);
B.
INSERT INTO <table_name>(column1, column2, …columnN) VALUES(value1 ,value2, …va lueN);
C.
INSERT <table_name>(column1, column2, …columnN), VALUES(value1, value2, …valueN
);
D.
INSERT INTO <table_name>(column1, column2,… columnN), VALUES(value1, value2,
…v alueN);