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