MySQL Question Regarding 'Null' Fields:

[So_1337]

When doing INSERT queries, how would I go about adding a "null" field. Just using '' doesn't seem to do it, it just leaves the field blank. I want it actually marked as null.

Thanks for any help =)

[Derision]

insert into test1 values('abc',NULL);

?

[So_1337]

Well no kidding, it really was that easy =) Thank you!

[Bulle]

You can try :
insert into rule_values values (12,'X',null);