Douglas Livingstone wrote:
> On Apr 7, 2005 7:59 PM, Phrogz <gavin / refinery.com> wrote:
> 
>>Jeremy Kemper wrote:
>>
>>>Regarding the preceding thread's speculation whether MySQL can tell
>>
>>you
>>
>>>whether a column is nullable: try 'desc tablename' in your client.
>>
>>Is this something that:
>>a) You can discover using a SQL query?
>>(I was told on on the #sql channel on IRC)
> 
> 
> Yes, using the SQL above: 'desc tablename'. It returns a result with
> the following fields: Field, Type, Null, Key, Default, Extra. If the
> Null filed is YES, then the field is "nullable".

The only DESC in SQL goes after an ORDER BY.

> Try it in MySQL.
> 
> Douglas

E