Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

how do I set number column to default NULL

Oct 27, 2001, 3:58 AM
macgruder
New User (2 posts)
Oct 27, 2001, 3:58 AM
Post #1 of 2
Views: 2499
Shortcut
Quote Reply
how do I set number column to default NULL
I have a NULL numeric column, but I can only seem to set default to zero or some numeric value. How do I set DEFAULT to NULL
Oct 27, 2001, 6:05 AM
macgruder
New User (2 posts)
Oct 27, 2001, 6:05 AM
Post #2 of 2
Views: 2426
Shortcut
Quote Reply
Re: [macgruder] how do I set number column to default NULL In reply to
oops! it's easy isn't it. to answer my own question: mysql automatically sets null numerics default to null.