Mysql批量执行dml语句(PHP)

 

<?php

    $mysqli=new MySQLi("localhost","root","root","database");
    if($mysqli->connect_error){
        die($mysqli->connect_error);
    }

    //定义多条sql语句
    $sqls="sql语句1";
    $sqls.="sql语句2";
    $sqls.="sql语句3";
    
    //............//

    //批量执行sql语句
    $bool=$mysqli->multi_query($sqls);
    if(!$bool){
        echo "执行失败".$mysqli->error;
    }
    else{
        echo "ok";
    }

    $mysqli->close();

?>