Re: mysql multi-row insert limitations?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom Reed wrote:

I have a lost of 25,000 unique words and I'd like to insert them into my
database.  Does anyone know if there is a limit to the number of rows you
can insert in one statement?

example insert: INSERT INTO table (word) VALUES ('tree'),('book'),
'apple') --> Enter's three rows in the database?



The limit is probably set somewhere else, like the size of the string that you can pass to mysql_query() or something similar. Even then, why don't you just split the records in blocks of X and insert them one block at a time?


   Bruno Ferreira
---
[This E-mail scanned for viruses by Declude Virus]

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux