mysql查看表字段 1.select COLUMN_NAME filedName from information_schema.COLUMNS where table_name = 'table_name' 例如:select COLUMN_NAME filedName from information_schema.COLUMNS where table_name = 'tb_user' 2.show full columns from table_name