select * from <表名> where rownum = 1;

SELECT A.COLUMN_NAME, A.* FROM all_tab_columns a 
WHERE table_name = 'Your Table Name'
AND A.COLUMN_NAME = 'COLUMN NAME' AND a.owner = 'Schema'

对于SQL Server:

SELECT [name] AS [Column Name]
FROM syscolumns
WHERE id = object_id('TABLE_NAME')

答案在这里:http://php.net/manual/en/function.mysql-list-fields.php 在你的情况下，我会使用以下代码:

$result = mysql_query("SHOW COLUMNS FROM sometable");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
$fields = array();
if (mysql_num_rows($result) > 0) {
    while ($row = mysql_fetch_assoc($result)) {
        $fields[] = $row['Field'];
    }
}

你可以这样做:

describe EVENT_LOG

or

desc EVENT_LOG

注意:只适用于你知道表名，特别是Oracle。

select * from <表名> where rownum = 1;