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



Reply via email to