Re: [MySQL] can you have a no-default column; error if unspecified?

2001-12-03 Thread Shankar Unni
Bennett Haselton wrote: > NOT NULL doesn't mean that the column doesn't have a default, it just > means that the default is not null. In other, more conventional (:-)), databases, NOT NULL means simply "NOT NULL", and implies nothing about defaults - that's a MySQL-ism. (Thus, a NOT NULL

Re: [MySQL] can you have a no-default column; error if unspecified?

2001-12-02 Thread Bennett Haselton
At 09:36 PM 12/1/2001 -0700, Ashley M. Kirchner wrote: >Bennett Haselton wrote: > > > Is it possible to set a column to have no possible default value, so if > you > > try to create a record that doesn't specify a value for that column, > you'll > > get an error? > > Set it to NOT NULL NOT

Re: [MySQL] can you have a no-default column; error if unspecified?

2001-12-01 Thread Ashley M. Kirchner
Bennett Haselton wrote: > Is it possible to set a column to have no possible default value, so if you > try to create a record that doesn't specify a value for that column, you'll > get an error? Set it to NOT NULL > For example, if I have a table where the "date" field should always be >