From: Douglas Livingstone <rampant@...>
Date: 2005-04-08T04:12:23+09:00
Subject: Re: In-depth schema details in ActiveRecord

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".

Try it in MySQL.

Douglas