On Tue, Jan 27, 2009 at 5:24 PM, Boyd, Todd M. tmbo...@ccis.edu wrote:
-Original Message-
From: Chris [mailto:dmag...@gmail.com]
Sent: Tuesday, January 27, 2009 4:04 PM
To: Boyd, Todd M.
Cc: php-general@lists.php.net
Subject: Re: [PHP] Global Changes With Loop To Allow Nulls In A
On 27 Jan 2009 at 8:53, 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
My Beginning attempt needs
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
My Beginning attempt needs help...
$i = 1;
while ($i =
On Tue, Jan 27, 2009 at 11:53 AM, revDAVE c...@hosting4days.com 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
-Original Message-
From: Andrew Ballard [mailto:aball...@gmail.com]
Sent: Tuesday, January 27, 2009 11:39 AM
To: revDAVE
Cc: php-general@lists.php.net
Subject: Re: [PHP] Global Changes With Loop To Allow Nulls In A
Table...
On Tue, Jan 27, 2009 at 11:53 AM, revDAVE
On Tue, Jan 27, 2009 at 12:58 PM, Boyd, Todd M. tmbo...@ccis.edu wrote:
-Original Message-
From: Andrew Ballard [mailto:aball...@gmail.com]
Sent: Tuesday, January 27, 2009 11:39 AM
To: revDAVE
Cc: php-general@lists.php.net
Subject: Re: [PHP] Global Changes With Loop To Allow Nulls In
The other responses should get you started if this is something you
really want to do. However, I'll play devil's advocate here and just
raise the question why you would want to make this change in the first
place. I'm not quite as anti-NULL as a lot of arguments I've read
against them, but I
-Original Message-
From: Chris [mailto:dmag...@gmail.com]
Sent: Tuesday, January 27, 2009 4:04 PM
To: Boyd, Todd M.
Cc: php-general@lists.php.net
Subject: Re: [PHP] Global Changes With Loop To Allow Nulls In A
Table...
The other responses should get you started if this is
Boyd, Todd M. wrote:
-Original Message-
From: Chris [mailto:dmag...@gmail.com]
Sent: Tuesday, January 27, 2009 4:04 PM
To: Boyd, Todd M.
Cc: php-general@lists.php.net
Subject: Re: [PHP] Global Changes With Loop To Allow Nulls In A
Table...
The other responses should get you started if
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;
[
10 matches
Mail list logo