Hi, The only limit I know is that in Java, Strings have s size limit of 2 GB.
By the way, I should use a prepared statement and parameters (bind variables). Inserting multiple rows at a time might make sense if you use the server mode; if not, I would simply use one row at a time. Regards, Thomas On Wed, Oct 9, 2013 at 4:35 PM, <[email protected]> wrote: > Hello, > > Is there a limit on the number of rows I can insert with one statement, > i.e. like this: INSERT INTO table VALUES (.., .., ...), (.., .., ...), ... > (.., .., ...); ? > > Thank you. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
