mysql 判断字段是否存在,可以使用3种命令
1. desc 命令
格式: desc tablename columnname
例子:
desc `ler_house_content` `content`
desc `ler_house_content` '%con%'
2. show columns 命令
格式: show columns from tablename like columnname
例子:
show columns from `ler_house_content` like 'content'
show columns from `ler_house_content` like '%content%'
3. describe 命令
格式: describe tablename columnname
describe 相當于 show columns from
例子:
describe `ler_house_content` `content`
describe `ler_house_content` '%con%'