PHP MySql一次插入n行？

Question

How can I optimize this code?

$items[0] = "Item-0";
$items[1] = "Item-1";
$items[2] = "Item-2";
$items[3] = "Item-3";
...
$items[n] = "Item-n";

foreach($items as $item) {
    mysql_query("INSERT INTO mytable (item) VALUES ('$item')");
}

The array is just sample and the key point I like to know is how can I insert n items without querying n times?

Thanks.

Answer 1

you can use mulitvalue insert statements

 insert into mytable(item) values('item1'),('item2') etc

http://dev.mysql.com/doc/refman/5.1/en/insert.html