-- step 1. get the column list of a table
select group_concat(name) as column_list
from pragma_table_info('[table_name]');
-- step 2. select those ALL-NULL rows, [column_list] is from the above
select *
from [table_name]
where coalesce([column_list]) is null;
1条答案
按热度按时间iovurdzv1#
也许只需输入一点内容,就可以得到您需要的结果:
举个例子:
第一次