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

This topic created in 1020 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