sqllist
Subject: Re: NULL value in VARCHAR fields SOLVED
hi list,
thanx for answering my question.
i recompiled mysql with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS
and now it works for me.
special thx to Shankar, who declared my problem in better words than
mine
and to Paul for knowing all from m
hi list,
thanx for answering my question.
i recompiled mysql with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS
and now it works for me.
special thx to Shankar, who declared my problem in better words than
mine
and to Paul for knowing all from mysqlDocu.
ttfn
stefan
--
st3V13h
nach diktat verreist
At 10:28 AM -0700 5/4/01, Shankar Unni wrote:
>Paul DuBois writes:
>
> > > At 8:21 PM +0200 5/3/01, 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 NUL
At 8:21 PM +0200 5/3/01, stefan mojschewitsch wrote:
>hi list,
>
>i have a problem with DEFAULT NULL value in a varchar field.
>mysql is version 3.23.33.
>
>i want to have an user field in a row, to see who has created the row.
>
> create table minidb.tel (
> id int UNSIGN
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 con
[EMAIL PROTECTED] wrote:
>
> Stefan,
>
> When you insert a row in a table and you do not specify a value
> for a field, mySQL (and any other DBMNS?) will do the following:
>
> 1. If field accepts null: it will set the value of that field
> to null
>
> 2. If field DOES NOT accept null - no defa
