From: John Berman Date: September 30 2005 8:40pm Subject: RE: Global Replace List-Archive: http://lists.mysql.com/mysql/189814 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sound advice, I have no done as suggested and my application handles the Nulls's Thanks John B -----Original Message----- From: Sujay Koduri [mailto:SujayK@stripped] Sent: 30 September 2005 14:26 To: Scott Noyes; JohnBerman@stripped Cc: mysql@stripped Subject: RE: Global Replace Yes, I don't think you have to do lot of changes to your application to achieve this. As scott mentioned, always try to keep minimum(whatever is really useful) data in the DB, either for more performance or for using less disk space. sujay -----Original Message----- From: Scott Noyes [mailto:snoyes@stripped] Sent: Friday, September 30, 2005 6:43 PM To: JohnBerman@stripped Cc: mysql@stripped 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 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 of your data by doing this. Functions designed to take advantage of NULL values will be lost to your applications. Your database will consume more disk space, and probably take longer to search. Leave the database fields as NULL, and design the output of your applications to display "No Data" where appropriate. -- Scott Noyes snoyes@stripped -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sujayk@stripped -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jberman@stripped -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.9/115 - Release Date: 29/09/2005