我在SQL Server中尝试过这个查询，这对我有用:

SELECT name FROM sys.columns WHERE OBJECT_ID = OBJECT_ID('table_name')

似乎有两种方法:

DESCRIBE `tablename`

or

SHOW COLUMNS FROM `tablename`

更多描述请点击:http://dev.mysql.com/doc/refman/5.0/en/describe.html

如果你只需要字段名和类型(可能是为了方便复制粘贴到Excel中):

SELECT COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='databasenamegoeshere'
AND DATA_TYPE='decimal' and TABLE_NAME = 'tablenamegoeshere'

删除

DATA_TYPE='decimal'

如果需要所有数据类型

你可以使用以下查询MYSQL:

SHOW `columns` FROM `your-table`;

下面是示例代码，它展示了如何在php中实现上述语法来列出列的名称:

$sql = "SHOW COLUMNS FROM your-table";
$result = mysqli_query($conn,$sql);
while($row = mysqli_fetch_array($result)){
    echo $row['Field']."<br>";
}

关于SHOW COLUMNS FROM TABLE输出的详细信息请访问:MySQL参考。

function get_col_names(){  
    $sql = "SHOW COLUMNS FROM tableName";  
    $result = mysql_query($sql);     
    while($record = mysql_fetch_array($result)){  
     $fields[] = $record['0'];  
    }
    foreach ($fields as $value){  
      echo 'column name is : '.$value.'-';  
}  
 }  

return get_col_names();

试试我个人使用的这个方法:

SHOW COLUMNS FROM $table where field REGEXP 'stock_id|drug_name'