用一条mysql语句插入多条数据

       假如有一个数据表A:

id name title addtime

        如果需要插入n条数据 :

$time= time(); $data = array( array( 'name'=>'name1','title'=>'title1','addtime'=>$time; ), array( 'name'=>'name2','title'=>'title2','addtime'=>$time; ), array( 'name'=>'name3','title'=>'title3','addtime'=>$time; ), ... array( 'name'=>'nameN','title'=>'titleN','addtime'=>$time; ), );

   之前我的想法会是，通过数据构造多条插入语句，循环调用 。如:     

$sql1 = "INSERT INTO `A`(`name`,`title`,`addtime`)VALUES ('name1','title1','".$time."')"; $sql2 = "INSERT INTO `A`(`name`,`title`,`addtime`)VALUES ('name2','title2','".$time."')"; ...... $sqlN = "INSERT INTO `A`(`name`,`title`,`addtime`)VALUES ('nameN','titleN','".$time."')";

   之后发现了sql的insert语句可以一次插入多条：

$sql = "INSERT INTO `A`(`name`,`title`,`addtime`)VALUES ('name1','title1','".$time."'),"; $sql .= "('name2','title2','".$time."'),"; $sql .= "('name3','title3','".$time."'),"; ..... $sql .= "('nameN','titleN','".$time."')";