|
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
Navigation:
[Reply to this message]
|