2006/1/7, Griggs, Donald <[EMAIL PROTECTED]>: > > Regarding: > > I want to use .import ... but the first line is the variable(fields), so I > want to ignore it. > ================================= > > Possible option #1: > > If it wouldn't violate any database-enforced constraints, why not import the > entire file, then delete the first row via SQL? > DELETE FROM mytable WHERE ROW_ID=1;
> Possible option #2: > > Are you using windows? If not, and if you weren't using SED in a piped > command (i.e., if you were copying the data via SED to a new file), then > changing to a piped command might lessen the time. > (Under windows, I believe a full file copy to a temporary file occurs with > piped commands, so I would expect no advantage.) > I am using windows. > Possible option #3: > > You could instead modify the source of the command-line tool, of course. > > > > Donald Griggs > > > Opinions are not necessarily those of Misys Healthcare Systems nor its board > of directors. >
