查询表时给字段赋默认值 sql

select 字段1,'X' as 字段2  from tableName w;

给表的字段2赋一个默认值X；