有如下定义,( )插入语句是正确的。 CREATE TABLE student (studentid int not null, name char(10) null, age int not null, sex char(1) not null, dis char(10) )
A.
INSERT INTO student VALUES(11,’abc’,20,’f’)
B.
INSERT INTO student(studentid,sex,age) VALUES (11,’f’,20)
C.
INSERT INTO student(studentid,sex,age) VALUES (11,20,’f’,NULL)
D.
INSERT INTO student SELECT 11,’ABC’,20,’F’,’test’