insert sql

hi, does anyone know how to insert a new record into the table and the all the values is set to null ?

Re: insert sql

Could you use:

INSERT INTO
   myTable
(
   field1,
   field2,
   field3,
   field4,
   field5
)
VALUES
(
   NULL,
   NULL,
   NULL,
   NULL,
   NULL
)

Terri

Re: insert sql

You could probably even do this, assuming none of the fields in the table have a "NOT NULL" constraint:

INSERT INTO
myTable
(
     field1
)
VALUES
(
     NULL
)

I dunno how much SQL you know so I may be saying the obvious to you, but just in case, you can just do one field and all the rest should default to NULL. If there are any required fields, then you have to have those in your insert statement, and assign some value to them. If it's autoincrement you need not worry about including it in your statement.