Posted by Jim Michaels on 02/12/06 00:01

"Dikkie Dik" <nospam@nospam.org> wrote in message
news:634d9$43ee086b$57d40752$11566@news.versatel.nl...
> First of all, you'd better ask in comp.databases.mysql
>
> You can insert more than one row with an insert command:
> INSERT INTO tblname(...)
> VALUES(...),
> (...),
> (...);

and in MySQL, you are limited to about I think 1MB per insert.(?) so you
must do it in chunks if it's big.


>
> Depending on the engine used, you could send it without being interested
> in the result:
> see http://dev.mysql.com/doc/refman/4.1/en/insert-delayed.html
>
> Best regards
>
> Chameleon wrote:
>> I have a SQL Script with about 5000 SQL Commands.
>>
>> How can I send it to SQL Server at once?
>>
>> I see mysql_query() fails on first semicolon (;) who delimits the SQL
>> Commands.
>>
>>
>> Another question:
>> I send to a MySQL server via fast Internet connection, about 500 INSERT
>> commands one by one via mysql_query().
>> It takes much time. Why?
>> I suspect that, mysql_query() after send the query to server, waits for a
>> "OK" response. If it's true, how can I send and send and send SQL
>> commands and MySQL server reply "OK" after send all these things?
>> (or no wait at all?)

[Back to original message]