Posted by Dikkie Dik on 02/11/06 17:53

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(...),
(...),
(...);

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]