mysql db user 表
int id,
field1 char,
field2 char,
field3 char,
......
假设我现在只知道这张表里有字段 id ，现在我想查询出表里内容为 null 的
字段所对应的字段名 fiels 和 id 号，
现在我只想到先查询表的所有字段，在循环查询得出结果这个办法，
有没有其他快捷的办法呢
This topic created in 3856 days ago, the information mentioned may be changed or developed.
 |
1
id4alex Nov 5, 2015
---现在我想查询出表里内容为 null 的
select * from user where id not in (select id from user where field1 is not null and field2 is not null .... and fieldn is not null) |
 |
3
heaton_nobu Nov 5, 2015
show columns from user
|
 |
4
msg7086 Nov 6, 2015
字段名也可以去 information_schema 找
|
Select Language