Re: Insert many records

[Alexander Burbello]

I know I can do it by application.
But I would like to know if are there other way to do the same.



sql, query

[EMAIL PROTECTED] escreve:

In a message dated 12/11/2002 18:46:08 GMT Standard Time, [EMAIL PROTECTED] writes:

Hi,
How can I insert many records (for instance: 1.000.000) without to do this
by application?
Are there a loop sintax like PL/SQL?
Regards

sql, query

either use BatchUpdate or a transaction.
Are you using ADO. ?
Sam

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php