mysql multi-row insert limitations?
| From: | Tom Reed | Date: | Fri, 16 Apr 2004 20:38:40 +0000 |
| Subject: | mysql multi-row insert limitations? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33930@lists.php.net to get a copy of this message | ||
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?
-tom