Recent

Author Topic: whether SQLQuery do script with many instructions INSERT INTO .......?????  (Read 3495 times)

abmservice

  • Jr. Member
  • **
  • Posts: 69
whether SQLQuery do script with many instructions INSERT INTO .......????

Lacak2

  • Guest
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

  • Full Member
  • ***
  • Posts: 171
in MySQL you can do
insert into TABLENAME VALUES (field1, field2...,fieldn), (field1, field2, field3), ...

as one SQL statement to insert multiple records.