if your output is from a query do
insert into mytable(col1, col2, col3)
(select col_a, col_b, col_c from othertable);
or
use the copy command
ex.
copy mytable from 'filepath/filename' using delimiters '\t';
you can also use stdin as the input path.
On Friday 27 May 2005 02:28 pm, Lo
I have a bunch of insert into statements just wondering if anyone knows
of more succinct way of doing multiple
Insert Into mytable(col1,col2,co3 etc) values ('one','two','three');
without repeating the Insert Into ?
thanks
Lori
---(end of broadcast)
Hi there,
I am using the groupware product egroupware.
When importing German Holidays (containing loads of umlauts), I get this
error:
"ERROR: Unicode characters greater than or equal to 0x1 are not
supported"
What caracter set would you recommend (we are using german language only).
Than
