ID | name | time |
1 | one | 1 |
2 | two | 2 |
3 | three | 3 |
使用一条SQL查询Id,name,type,time ,如果name=one,那type=1,反之type=0
答:
select id,name,time,if(name='one',1,0) as type from tableName
ID | name | time |
1 | one | 1 |
2 | two | 2 |
3 | three | 3 |
使用一条SQL查询Id,name,type,time ,如果name=one,那type=1,反之type=0
答:
select id,name,time,if(name='one',1,0) as type from tableName