Sound advice, I have no done as suggested and my application handles the
Nulls's
Thanks
John B
-Original Message-
From: Sujay Koduri [mailto:[EMAIL PROTECTED]
Sent: 30 September 2005 14:26
To: Scott Noyes; [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Global Replace
"John Berman" <[EMAIL PROTECTED]> wrote on 09/29/2005 06:05:42 PM:
> Hi
>
> We have a database on MySql 4 and it contains many tables. In each field
in
> the table in the past were there was no data to display we simply left
the
> field blank, we now want to replace a null entry with No Data
>
ailto:[EMAIL PROTECTED]
Sent: Friday, September 30, 2005 6:43 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Global Replace
> We have a database on MySql 4 and it contains many tables. In each
> field in the table in the past were there was no data to display we
> simply
> We have a database on MySql 4 and it contains many tables. In each field in
> the table in the past were there was no data to display we simply left the
> field blank, we now want to replace a null entry with No Data
I advise you to reconsider. You are reducing the flexibility and
usefullness
Hi
We have a database on MySql 4 and it contains many tables. In each field in
the table in the past were there was no data to display we simply left the
field blank, we now want to replace a null entry with No Data
I have no problem doing this on an individual field in each table like so
UPDA
