insert multiple records into table



hello all,

I am not sure of the syntax, to insert multiple records into a table in
1 command like:

$dbh->do("INSERT INTO TestTable (Key1),(Key2) VALUES ('value1
'),('value2')");

or something like:

$dbh->do("INSERT INTO TestTable (Key1) VALUES ('value1'), (Key2) VALUES
('value2')")

Any Suggestions,
Thank you,

.



Relevant Pages

  • Re: Accesing structures data (getting lengthy!)
    ... According to the syntax you ... assignment statement just won't stand out amongst all the other ... meaningless dummy variables that you have to keep track of. ... comparitively easy to pick out of a long, boring, command line history, ...
    (comp.soft-sys.matlab)
  • Re: Windows could not upgrade the file..........Security update KB
    ... "Sky King" wrote in message ... > Robert Aldwinckle wrote: ... I would not have offered my tip about copying text from a command ... probably over a simple syntax error. ...
    (microsoft.public.windowsupdate)
  • Re: krb5kdc_err_s_principal_unknown on Windows Kerberos Domain
    ... command line with the parameter "tickets". ... fail group policy replication for users. ... I went to the command line and tested this unusual syntax, ...
    (comp.protocols.kerberos)
  • Re: coding a command button to change properties on another form
    ... Try placing your disable code in the Form2 OnOpen event. ... OpenArgs string is passed to Form2, so that Form2 can examine and act/notact upon it. ... the syntax for the FormOpen method is wrong... ... On this command button that has a macro, ...
    (microsoft.public.access.formscoding)
  • Re: Accesing structures data (getting lengthy!)
    ... I have an easier time prototyping and coding, and in my situation it's easier, but its really a kludge, and suffers from some of the same problems that your syntax does, which I'll describe below. ... My prototyping work from the command line is hard enough to make sense of more than two minutes after I've typed it right now--I don't need to add to it by creating a fruit salad of placeholders and dummy variables. ... It doesn't create a fruit salad of meaningless dummy variables that you have to keep track of. ... Use a specified field of a structure. ...
    (comp.soft-sys.matlab)