mysql 查询字段为空默认值
解决方案:
如果name为空,则赋默认值:defaultValue 。结果如图所示【为空默认值.jpg】
select name,if(name is null or name="","defaultValue",name) pression from tablename;
http://www.myexception.cn/h/1379304.html
================================================================
mysql判断字段是否存在的方法
1. desc 命令
格式: desc tablename columnname
例子:
desc `table` `mid`
desc `table` '%abc%'
2. show columns 命令
格式: show columns from tablename like columnname
例子:
show columns from `table` like 'mid'
show columns from `table` like '%abc%'
3. describe 命令
格式: describe tablename columnname
describe 相當于 show columns from
例子:
describe `table` `mid`
describe `table` '%abc%'
http://www.jb51.net/article/46149.htm
--===========================================
mysql判断表中的列是否存在
select count(*) from information_schema.columns where table_schema='库名' and table_name='表名' and column_name='列名'
mysql 判断表字段或索引是否存在,然后修改
http://www.cnblogs.com/yplong/p/3968828.html