employee表有三列:empid,lastname,salary,现在要将一条记录插入employee表,该记录在empid列的值为5678,lastname的值为Henry,salary没有值,正确的语句是?
A.
insert into employee values(5678,'Henry')
B.
insert into employee values(5678,'Henry',null)
C.
insert into employee(empid,lastname ,salary) values(5678,'Henry')
D.
insert into employee(lastname,empid) values(5678,'Henry')