Re: Global Changes With Loop To Allow Nulls In A Table...
| From: | revDAVE | Date: | Wed, 28 Jan 2009 05:21:33 +0000 |
| Subject: | Re: Global Changes With Loop To Allow Nulls In A Table... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287263@lists.php.net to get a copy of this message | ||
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]