I'm trying to insert a NULL value into a column that is
expecting an integer, i've tried
INSERT INTO mytable (intvalue) VALUES (NULL)
as well as
INSERT INTO mytable (intvalue) VALUES ('NULL')
both of which resulted in a 0 being inserted.
with other DMBS's I've used this is ok..
-- Jeff
expecting an integer, i've tried
INSERT INTO mytable (intvalue) VALUES (NULL)
as well as
INSERT INTO mytable (intvalue) VALUES ('NULL')
both of which resulted in a 0 being inserted.
with other DMBS's I've used this is ok..
-- Jeff