On Sat, 2005-02-19 at 23:55, David Blomstrom wrote: > > Why not set columns to NOT NULL and default to space > > for character and 0 > > for numeric? > > OK, you're suggesting I... > > 1. Set all the columns to NOT NULL > 2. Set 0 as the default for numeric fields > 3. Set "space" for the default in the other fields?
Using a single space as the default for a column won't work because mysql trims (removes trailing whitespace) from inserted values. Doing something like this sounds like a really bad work around. The data you want should be stored and appear in the right columns. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
