Mysql中表student_info(id,name,birth,sex),字段类型都是varchar,插入:1018 , 赵六 , 2003-08-02 , 男;
SQL正确的是()?
insert overwrite student_info values('1018' , '赵六' , '2003-08-02' , '男');
insert into student_info values(1018 , '赵六' , '2003-08-02' , '男');
insert into student_info(`birth`,`id`,name,`sex`) values('2003-08-02' ,'1018' , '赵六' , '男');
insert into student_info value('1018' , '赵六' , '2003-08-02' , '男');