Code: Select all
insert into tablename(field1,field2,field3) values ('value1','value2','value3'),('valuex','valuey','valuez'),('valuen','valuem','valueo')
Code: Select all
insert into tablename(field1,field2,field3) values ('value1','value2','value3'),('valuex','valuey','valuez'),('valuen','valuem','valueo')
Code: Select all
insert into "TARGET" (SELECT NULL, "PATNO","DATE","AMOUNT" FROM "SOURCE" WHERE YEAR("DATUM")=2012)
Code: Select all
INSERT INTO "TARGET" (SELECT NULL, "PATNO","DATE","AMOUNT" FROM "SOURCE" WHERE "SOURCE"."PK" NOT IN (SELECT"PK" FROM "TARGET"))