[thelist] Insert Nothing

Joshua Olson joshua at waetech.com
Mon Sep 27 13:58:16 CDT 2004

> -----Original Message-----
> From: Rob Smith
> Sent: Monday, September 27, 2004 2:10 PM
> Hi list,
> I want to insert nothing into an SQL Server table.
> INSERT INTO myTable () VALUES ()
> My table structure is this:
> caid		int		4		not null
> auto_increment
> timevisited	datetime	8		not null	(getdate())


I'm not sure that you can insert an empty, but you could always:

INSERT INTO myTable(timevisited) VALUES (GetDate())

On a side note, you may want to consider dumping this information to a text
file and then performing a bulk import--if you don't need to have this data
real-time.  Doing it this way will improve performance in situations where
you have a large number of visitors.

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list