以下插入记录正确的( )
A. insert into student(name,hiredate,sal) values (value1,value2,value3);
B. insert into student (name,sal)values(value1,value2,value3);
C. insert into student (name)values(value1,value2,value3);
D. insert into student (name,hiredate,sal)values(value1,value2);
若顺序执行以下SQL语句:CREATE TABLE tb( id unsigned int(6) primary key auto_increment,name char(8) not null,sex char(2) default “女”);insert into tb (name) values (“张三”);,最后执行select * from tb的结果是 ( )
A. NULL张三女
B. 张三
C. 张三女
D. 1 张三女