sql 中的字典值魔法数字怎么处理?

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 1015 days ago, the information mentioned may be changed or developed.

代码中常见的魔法数字处理方式是定义常量枚举,那么 sql 中呢?

select * from table where type = '1'

const web = 1
const app =2

select * from table where type = '+web+'

select * from table where locate('+web+',type)>0 or locate('+app+',type)>0

No Comments Yet

type select table Where