insert a null value?


does know how insert null value?

for example:

insert tbl_table (col1,col2)
values (null,null)

thanks.

insert tbl_table (col1,col2)
values (null,null)
this query insert null db, if column "not null" property false. otherwise null can't inserted db. if "not null" true then,
insert tbl_table (col1,col2)
values ('','') blank value can inserted, not null.

thanks

sankalan
(www.mindfiresolutions.com)


More discussions in Database Access


adobe

Comments