If you just reply to this message, and include the entire text of it in
the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. You have written the following:
hi,
"j.urban" wrote:
>
> Your statement contradicts itself. You can't have a constraint that
> forbids a column from accepting NULL values and then insert a default NULL
> value into that column... Do you want the string 'null' to be inserted as
> the default?
>
> iuser varchar(255) NOT NULL DEFAULT 'NULL',
>
> If you want the column to accept NULLs, then:
>
> iuser varchar(255) DEFAULT NULL,
>
> Perhaps I'm not understanding your question...
i want to have inserts like
insert into tel set tel='+49 815 4711', service=1;
to be rejected, and
insert into tel set tel='+49 815 4711', service=1,iuser=USER();
accepted.
ttfn
stefan
and to make the listFilter happy :-) database,sql,query
>
> On Thu, 3 May 2001, stefan mojschewitsch wrote:
>
> > using DEFAULT USER(), would be nice, but only constants are allowed.
> > to prevent inserting rows without iuser, i like to have this field
> > with NOT NULL restriction and default value NULL.
--
st3V13h
nach diktat verreist
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
