 | | | Spam:Re: Spam:Null Defaults | Spam:Re: Spam:Null Defaults 2004-12-17 - By F?bio L?cio Meira
Back
At 09:46 17/12/2004, Mark Mchugh wrote:
>seems not to be in my database, when looking at it
>through the mysql control center i just see blanks,
>but when i add a record, then it will add NULL to the
>field when there is not data
Ok. But at canonic specification of Data Bases (you coulde see at
Elmasri/Navathe, Date, or Korth)
a Null field is a empty field. I think that this is just the way that the
GUI of MySQL works on Null fields.
>--- Fabio Lucio Meira <fabiomeira@(protected)>
>wrote:
>
> > At 09:39 17/12/2004, Mark Mchugh wrote:
> > >Hi Everybody,
> > >Just a quick one...... if i have a number of fields
> > >defined in a table, and there is data in the table,
> > >and i want a default of null, is there any way to
> > >change all empty values to null?
> >
> > I didn't understand. If a field is empty then it's
> > NULL, is not?
> >
> > >many thanks
> > >
> > >
> > >
> > >
> > >__ ____ ____ ____ ____ ____ ______
> > >Do you Yahoo!?
> > >Jazz up your holiday email with celebrity designs.
> > Learn more.
> > >http://celebrity.mail.yahoo.com
> > >
> > >--
> > >MySQL Windows Mailing List
> > >For list archives: http://lists.mysql.com/win32
> > >To
> > >unsubscribe:
> >
>http://lists.mysql.com/win32?unsub?biomeira@(protected)
> >
> >
> > -- ---- --
> > F?bio L?cio Meira
> > Coordenador - Sistemas de Informa??o
> > Centro Universit?rio S?o Camilo
> > Esp?rito Santo - (28) 3526.5917
> >
> >
>
>
>
>
>__ ____ ____ ____ ____ ____ ______
>Do you Yahoo!?
>Send holiday email and support a worthy cause. Do good.
>http://celebrity.mail.yahoo.com
-- ---- --
F?bio L?cio Meira
Coordenador - Sistemas de Informa??o
Centro Universit?rio S?o Camilo
Esp?rito Santo - (28) 3526.5917
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|