1. 查询某个数据库中某个表的所有列名
SELECT COLUMN_NAME
FROM information_schema
.COLUMNS
WHERE TABLE_SCHEMA
= 'db_name' AND TABLE_NAME
= 'tb_name';
2. 查询某个数据库中某个表的所有列名,并用逗号连接
SELECT GROUP_CONCAT
(COLUMN_NAME SEPARATOR
",") FROM information_schema
.COLUMNS
WHERE TABLE_SCHEMA
= 'db_name' AND TABLE_NAME
= 'tb_name';
如果不需要指定列 可以追加 and COLUMN_NAME != ‘id’
3. 数据库快速备份指定列
insert tb_name_1 ${第二步查出来的列} SELECT ${第二步查出来的列} from tb_name_2
