On Tue, 6 Mar 2001 11:14:36 +0100, Fred van Engen <[EMAIL PROTECTED]>
wrote:
Thanks Fred,
>>INSERT INTO referral
>> VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
>>
>>
>>But an INSERT like this:
This is where I was making the mistake! It works fine now. I was inserting an
blank empty value instead of NULL! DUH!!...
>>INSERT INTO referral
>> VALUES ('', 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
>>
>>will probably use 0 for refer_id or give an error message. You do
>>supply a value in this case, so no default wil be used.
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
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