Posted by Stefan Rybacki on 10/02/05 12:30

Disco Octopus wrote:
> 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.
>

SHOW COLUMNS FROM table

Then you get a listing of all columns and their properties. You're interesseted in the
Null property

Regards
Stefan


> Thanks
>

[Back to original message]