You can also import data from a text file with comma-separated fields using Derby's SYSCS_UTIL.SYSCS_IMPORT_DATA() built-in procedure...
CREATE TABLE TAB1 (c1 VARCHAR(30), c2 INT)
CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL, 'TAB1', null, null, 'myfile.del',null, null, null, 0)
With myfile.del containing data sych as:
More info at:
You can also create a table out of another existing table and specify which (if not all) columns you want to have:
CREATE TABLE TAB1 AS SELECT c1, c2 FROM TAB3 WITH NO DATA;
You can find a list of Derby's SQL commands in the Reference guide:
is there a COPY command applicable in derby? I know this from
COPY table (column1, column2) FROM stdin;
I tried it with SQuirreL but had no success. Btw. where do I find a
reference of supported SQL commands in derby?
Thank you very much,