close
1.insert into cities (id,name) values( 69,'shit') ,(68,'ii')
2.
select id, case
approve when 0 then '通過' else '沒通過' end as status
from users
3.
select id,total_price,case when total_price > 200 then '打3折' when total_price <=200 then '打8折' end as 'count' from invoices
全站熱搜
留言列表
