-->

科技资讯

您的当前位置:首页 > 资讯 > MySQL

select小技巧-增加自定义行或列

2019-11-05 15:30:49  来源:admin 点击:904

select 查询多一行自定义列表

select 0 as id,'请选择' as title union all

select gid as id,gname as title from 表名 where status=0 

select 查询多一列自定义字段

select gid as id,gname as title ,0 as pid from 表名 where status=0 


相关文章更多 >

© 2024版权所有 水水网

电话:171780793