Posted by Gordon Burditt on 07/21/07 04:39

>For this table
>---------------------------------------
>| id | foo | bar |
>--------------------------------------
>
>I understand that we can insert a row to the table per call, like this
>sql_query = "INSERT INTO `table` (`foo`, `bar`) VALUES ('$string_1',
>'$string_2')";
>mysql_query($sql_query, $db_handle);
>
>if I want to insert multi rows(the following example inserts two rows)
>at the same time, the following example works, but can I merge this
>two insertion into a single mysql operation (to achieve efficiency)?
>
>sql_query = "INSERT INTO `table` (`foo`, `bar`) VALUES ('$string_1',
>'$string_2')";
>mysql_query($sql_query, $db_handle);
>sql_query = "INSERT INTO `table` (`foo`, `bar`) VALUES ('$string_1',
>'$string_2')";
>mysql_query($sql_query, $db_handle);

INSERT INTO `table` (`foo`, `bar`) VALUES
('$string_1', '$string_2'),
('$string_3', '$string_4'),
('$string_5', '$string_6'),
('$string_7', '$string_8');

Warning: you are limited in the length of the query you can have by
some mysql parameters, so depending on the length of the strings, you
may need to limit this to a few thousand records at a time.

• Next in forum: Re: return search results on same page
• Prev in forum: Re: Type of Data Returned by a Function
• Thread view: Re: insert multi rows with a single mysql function call?

[Reply to this message]