Insert many records
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 - 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
Re: Insert many records
You could pu tmany records in a file and use mysql -u user -p infile.sql to load in al the records in the file. Or try http://www.mysql.com/doc/en/LOAD_DATA.html -Corey Tisdale The Grill Store More --- Alexander Burbello [EMAIL PROTECTED] wrote: 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 - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
RES: Insert many records
Try to use AccessDump. It generate multiples INSERT, one for each row. It´s so good. http://www.intranet2internet.com/public/default.asp Lucky Jacob -Mensagem original- De: Alexander Burbello [mailto:burbello;pop.com.br] Enviada em: terça-feira, 12 de novembro de 2002 16:29 Para: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Assunto: Insert many records 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 - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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
Re: Insert many records
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