Re: NULL and database size

2005-08-19 Thread Devananda
Robert Crowell wrote: I have data from two different sources that I would like to store in a mysql database. Dataset_1 has pieces of information A, B, and C (let's say first, middle, and last name) and Dataset_2 has pieces of information A, B, C, and D (first, middle, last names and a DOUBLE val

Re: NULL and database size

2005-08-19 Thread Keith Ivey
Robert Crowell wrote: However, if the table was created with columns A, B, C, and D, most of the entries in the D column will be NULL. Is this considered 'good form'? Even though these entries are all NULL, they will still consume the disk space that a DOUBLE will, correct? I can't find it i

NULL and database size

2005-08-19 Thread Robert Crowell
I have data from two different sources that I would like to store in a mysql database. Dataset_1 has pieces of information A, B, and C (let's say first, middle, and last name) and Dataset_2 has pieces of information A, B, C, and D (first, middle, last names and a DOUBLE value). Dataset_1 has 9.5