On Thu, Jan 21, 1999 at 12:29:30PM -0500, Jim Faucette wrote:
> Making the field a PRIMARY KEY or UNIQUE INDEX, will solve your problem.
> If that's not possible, then test the input before creating the INSERT
> query.
There is a compile-time flag that will disable the use of default
values in MySQL. From the manual:
shell> CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure
This isn't exactly what you want maybe. On the TODO list is to
disable "implicit" default values for not-NULL columns. I'm not
sure when this will be available, probably some release of 3.23.
In the mean time, you're probably best off validating all of the
user-supplied data yourself before you attempt the insert.
Tim
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
