执行多条SQL语句_sql语句执行顺序

执行多条SQL语句由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“sql语句执行顺序”。

执行多条SQL语句

使用mysqli一次执行多条SQL语句

$mysqli=new MySQLi(“localhost”,“root”,“”,“xiaoqiangdb”);

/*==========================没有结果集:insert update delete==========================*/

$sqls=“insert into shops(name,price,num,desn)values('book1','12.16','5','good');”;

$sqls.=“updated shops set name='testname' where id>50;”;

$sqls.=“delete from shops where id

if($mysqli->multi_query($sqls)){

echo ”多条语句执行成功!“;

echo ”最后插入的ID:“.$mysqli->insert_id.”“;

//echo ”影响的行数:“.$mysqli->affected_rows;//不准确!

}else{

echo ”ERROR“.$mysqli->errno.”---“.$mysqli->error;

}

/*==========================有结果集:select==========================*/$sqls=”select current_user();“;

$sqls.=”desc shops;“;

$sqls.=”select * fron shops“;

if($mysqli->multi_query($sqls)){

echo ”多条语句执行成功!“;

do{

$result=$mysqli->store_result();//获取结果集

echo '';

echo '';

while($field=$result->fetch_field()){

echo ''.$field->name.'';

}

echo '';

while($row=$result->fetch_aoc()){

echo '';

foreach($row as $col){

echo ''.$col.'';

}

echo '';

}

echo '';

if($mysqli->more_results()){//判断还有没有结果集echo ”“;

}

}while($mysqli->next_result());//取得下一个结果集}else{

echo ”ERROR“.$mysqli->errno.”---".$mysqli->error;}

$mysqli->close();

?>