revDAVE wrote:
Hi Folks,
Newbie question....
I have a mysql table with 100 fields, currently all do not allow nulls.
Rather than hand typing in phpMyAdmin, I would like a way to loop through
all fields and update them to allow nulls....
First I would DESCRIBE the table so you get a list of column names and
attributes. Then I would go thru each column and CHANGE it so it has
the same attributes, adding the NULL flag if necessary.
There may be an easier way however.
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php