MySQL-如何在一行中运行多个更新查询? [英] MySQL - How to run multiple update queries in one line?
本文介绍了MySQL-如何在一行中运行多个更新查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
$sql = "UPDATE user SET password = '$new_password' WHERE temp_url = '$temp_code';";
$sql = "UPDATE user SET temp_url = '' WHERE user_name = '$user_name_frmdb';";
如何在同一行中运行两个更新查询?
How can I run the two update queries in one line?
推荐答案
使用您可以实现的Mysqli扩展,您可以使用mysqli_multi_query运行多个查询:
Using Mysqli extention you can implement, you can run multiple queries using mysqli_multi_query:
$sql = "UPDATE user SET password = '$new_password' WHERE temp_url = '$temp_code';";
$sql .= "UPDATE user SET temp_url = '' WHERE user_name = '$user_name_frmdb';";
// Execute multi query
if (mysqli_multi_query($con, $sql)) {
// Query successful
}
这篇关于MySQL-如何在一行中运行多个更新查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文