Re: Global Changes With Loop To Allow Nulls In A Table...

[revDAVE <Cool@xxxxxxxxxxxxxxxx>]

Thanks so much for everyone's help!

I fooled with this and it was cool...

In the mysql client, do a SHOW CREATE TABLE tableName\G

And ultimately got it working with:


---------

The MySQL syntax to alter a column is:

    ALTER TABLE `table` MODIFY `column` BIGINT NOT NULL;

    [ http://dev.mysql.com/doc/refman/5.1/en/alter-table.html ]

The sql statement

    SHOW COLUMNSFROM `table`;

    [ http://dev.mysql.com/doc/refman/5.1/en/show-columns.html ]

Thanks again!!!!


--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php