Posted by Oli Filth on 10/02/05 12:29

Disco Octopus said the following on 02/10/2005 07:39:
> Hi,
> I would like to know if it is possible for me to find out if a column in
> a MySQL table is defined as "Not Null". I would like to do tis at run
> time.
>

Execute the following query:

SHOW COLUMNS FROM myTable

The resulting recordset has information about each column of the table,
including whether it can accept NULL values.


--
Oli

[Back to original message]