如何将两个查询放在一个mysql_query中? [英] How can I put two queries in one mysql_query?

问题描述

我正在尝试做这样的事情:

I'm trying to do something like this:

mysql_query("
  UPDATE name SET money = money + 1;
  UPDATE surname SET money = money + 1;
"); 

但它不起作用.

这只是示例，但我的问题是:如何在一个mysql_query中放置两个或更多查询?

It's just example, but my question is: How can I put two or even more queries in one mysql_query?

推荐答案

http://docs.php.net/mysql_query 说:

mysql_query()向与指定的link_identifier关联的服务器上的当前活动数据库发送唯一查询(不支持多个查询).

mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier .

但是您可能对 mysql i :: multi_query :

But you might be interested in mysqli::multi_query:

执行一个或多个由分号连接的查询.

Executes one or multiple queries which are concatenated by a semicolon.

这篇关于如何将两个查询放在一个mysql_query中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！