Hello all,
I want to know how to get information about field types. I am
using MyISAM.
I can see some MySQL instructions that can do this for one field at a time but
I want to get the
stats for a whole table at once.
For example -
How do I get information on each field of a table as to weather or not that
field can be null?
And how do I get each data type for each of the fields in a table?
I need the 'NOT NULL' / 'NULL' to force the administrator to allow access to
this field for users
who are permitted to add data items.
I also need the data type so that I can associate validation REGEX with a field
type as the data
base is too broad to script individual field validations in php.
Any pointers for REGEX for various MySQL data types would be greatly
appreciated as I have no real
experience with REGEX.
Thanks all, Robert.
