e benefit.
I stand corrected. Still, as you've noticed, don't change the design of an
existing application without thoroughly testing the consequences :-p
- Original Message -
> From: sono...@fannullone.us
> To: mysql@lists.mysql.com
> Sent: Tuesday, 14 June, 2011 7:34
On Jun 7, 2011, at 10:43 PM, Johan De Meersman wrote:
> Where did you find the advice about setting columns NOT NULL?
It took me awhile, but I just found it again, in case anyone is
interested:
http://dev.mysql.com/doc/refman/5.0/en/data-size.html
7.8.1. Make Your Data as Small as Pos
>> If that's all you did, you indeed 'removed the default NULL' but did not
>specify another default. Hence, if you don't explicitly specify a value in
>your
>insert statement, the insert can not happen as the server doesn't know what
>to
>put there and is explicitly disallowed from leaving the
On Jun 7, 2011, at 10:43 PM, Johan De Meersman wrote:
> If that's all you did, you indeed 'removed the default NULL' but did not
> specify another default. Hence, if you don't explicitly specify a value in
> your insert statement, the insert can not happen as the server doesn't know
> what to p
- Original Message -
> From: sono...@fannullone.us
>
> Yes. That's all I did.
If that's all you did, you indeed 'removed the default NULL' but did not
specify another default. Hence, if you don't explicitly specify a value in your
insert statement, the insert can not happen as the serv
> On Jun 6, 2011, at 10:06 PM, Johan De Meersman wrote:
> > What exactly do you mean by "removing the NULL default"? Did you set
> > your colums NOT NULL?
>
> Yes. That's all I did.
In stead of getting info drop-by-drop, you might want to share the output of
SHOW CREATE TABLE...,, but my
On Jun 6, 2011, at 10:06 PM, Johan De Meersman wrote:
> What exactly do you mean by "removing the NULL default"? Did you set your
> colums NOT NULL?
Yes. That's all I did.
Marc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
- Original Message -
> From: sono...@fannullone.us
>
> description? Why would removing the NULL default cause data to be
> lost?
What exactly do you mean by "removing the NULL default"? Did you set your
colums NOT NULL?
--
Bier met grenadyn
Is als mosterd by den wyn
Sy d
Hopefully I won't look like too much of a numbskull here but after
reading some sites on table optimization, I decided to remove the NULL as
default on the fields in my products table. I thought everything went well
until I realized that we hadn't received any orders for 2 days. That's
