PHP ²åÈë´óÁ¿mysql¼Ç¼µÄÎÊÌâ

for($i=1;$i <=10000;$i++){
$sql="insert into l(name,age,info) values('Ãû×Ö$i',$i,'½éÉÜ$i')";
mysql_query($sql);
}

ÎÒÕâÑùµÄ²åÈë·½·¨..´ó¸Å²åÈë300Ìõ×óÓҾͣº
Fatal error: Maximum execution time of 30 seconds exceeded in D:\Backup\phptest\index.php on line 9

ÇëÎÊÓÐʲô¸ÄÁ¼µÄ°ì·¨²»£¿

---

$sql="insert into l(name,age,info) values"
for($i=1;$i <=10000;$i++){
$sql.="('Ãû×Ö$i',$i,'½éÉÜ$i'),";

}
$sql=substr($sql,0,-1);
mysql_query($sql);

---

PHP code:

set_time_limit(0);//¼ÓÉϲ»ÏÞʱ
for($i=1;$i <=10000;$i++){
$sql="insert into l(name,age,info) values('Ãû×Ö$i',$i,'½éÉÜ$i')";
mysql_query($sql);
}

---

ͬÒâ2#

---

for($i=1;$i <=10000;$i++){
$sql="insert into l(name,age,info) values('Ãû×Ö$i',$i,'½éÉÜ$i')";
mysql_query($sql);
}

sql ±àÔÚÒ»Æð
Ò»´ÎÖ±½Ó
$sql="insert into l(name,age,info) values";
for($i=1;$i <=10000;$i++){
$sql .="('Ãû×Ö$i',$i,'½éÉÜ$i'),";

}
$sql = substr($sql,0,-1);
mysql_query($sql);

---

ÔçÉÏû˯ÐÑд´íÁË,LZÖªµÀÒâ˼¾Í¿ÉÒÔÁË= =

---

PHP code

---

Code highlighting produced