At 14:34 -0700 7/28/02, Charlie wrote:
>Is there any storage / performance penalty for specifying '' or 0 as default
>values, as opposed to allowing null's in the table structure?

NULL values take less storage space.  (One bit per NULL value in a row,
if I remember correctly).

>
>sql, query
>
>Thanks,
>Charlie


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to