Mysql查询排除某个字段的列名称
2022-08-11 本文已影响0人
codeduck1
图片.png
SELECT CONCAT(' select ',GROUP_CONCAT(COLUMN_NAME),' from ', TABLE_NAME,' ;')
FROM information_schema.COLUMNS WHERE table_name = 'tb_real_estate' AND TABLE_SCHEMA = 'li_ling' and COLUMN_NAME != 'eid' and COLUMN_NAME != 'estate_num';
show full fields from 表名;
show index from 表名;
show create table 表名;
