Which of the following statements will successfully insert a row into the employee table?
insert into employee values set employeeID=NULL, name='Laura Thomson', job='Programmer', departmentID=128;
insert employee values (NULL, 'Laura Thomson', 'Programmer', 128);
insert into employee values (NULL, Laura Thomson, Programmer, 128);
insert employee values (NULL, 'Laura O'Leary', 'Programmer', 128);
The REPLACE statement
is similar to INSERT except that where a key clash occurs, it will replace the old row with the new row
is similar to INSERT except that where a key clash occurs, it will keep the old row and discard the new row
is similar to UPDATE except that where a key clash occurs, it will replace the old row with the new row
is similar to UPDATE except that where a key clash occurs, it will keep the old row and discard the new row
The --i-am-a- dummy startup option for the mysql client
prevents you from inserting any data
prevents you from updating data without specifying a key constraint
prevents you from deleting data without specifying a key constraint
both b) and c)
By default, fields in data files for load data infile are separated by
commas
spaces
tabs
pipes
The optional LOCAL clause in LOAD DATA INFILE
specifies that the client and server are running on the same machine
specifies that the data file is on the server
specifies that the data file is on the client
specifies that the server is running on the local host