|
-
Oct 22nd, 2002, 12:30 PM
#2
No, since there could be fields (like VARCHAR or BLOB) that don't accept 0 as value. In one query you could set every field to 0 (or something similar) if the field you check for in the row is null.
But you could use more than one query like
UPDATE tablename fieldname='0' WHERE fieldname=NULL
UPDATE tablename otherfield='0' WHERE otherfield=NULL
But don't rely on what I've said, I've never got deep into obscure SQL commands.
All the buzzt
 CornedBee
"Writing specifications is like writing a novel. Writing code is like writing poetry."
- Anonymous, published by Raymond Chen
Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|