<p>I am connecting to a MySQL DB trough a terminal who only have a program with an ODBC connection to a MySQL DB. I can put querys in the program, but not access MySQL directly.</p>

<p>I there a way to query the DB to obtain the list of fields in a table other than</p>

<pre><code>select * from table
</code></pre>

<p>??</p>

<p>(don't know why but the select returns a error)</p>

```
```
describe *tablename*
```
```