whether SQLQuery do script with many instructions INSERT INTO
.......?????
lazarus / 16-Databases

----------------------------------------------------------------------
abmservice · 2010-04-13 17:49

whether SQLQuery do script with many instructions INSERT INTO
.......????

----------------------------------------------------------------------
Lacak2 · 2010-04-14 04:21

IMHO it depends on backend database if it support batch SQL commands.
for example in case of MySQL it requires setting flag
CLIENT_MULTI_STATEMENTS at connection time (which is not done now)

----------------------------------------------------------------------
bobo · 2010-04-16 06:58

in MySQL you can do
insert into TABLENAME VALUES (field1, field2...,fieldn), (field1,
field2, field3), ...

as one SQL statement to insert multiple records.