单项选择题
有如下定义,( )插入语句是正确的。CREATE TABLE student (studentid int not null, name char(10) 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