select '','',no,name from student
查询语句中返回的字段如果有多个默认值给的是‘’,则会导致报错
可以给他们取别名避免错误
select ‘’ as sex, '' as score , name from student
select '','',no,name from student
查询语句中返回的字段如果有多个默认值给的是‘’,则会导致报错
可以给他们取别名避免错误
select ‘’ as sex, '' as score , name from student