Insert many records

2002-11-12 Thread Alexander Burbello
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

Re: Insert many records

2002-11-12 Thread Corey Tisdale
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

RES: Insert many records

2002-11-12 Thread Carlos Eduardo de Rezende Jacob
: [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

Re: Insert many records

2002-11-12 Thread 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