多个命令 [英] Multiple commands

问题描述

在我的PHP代码中，我想执行以下两个命令：


使用mydb;

select * from mytbl;


现在，我可以使用以下语句：


$ SQL =" use mydb";

$ result = mysql_query（$ SQL）;


$ SQL =" select * from mytbl" ;;

$ result = mysql_query（$ SQL）;


我真正想做的是某事。喜欢：


$ SQL =" use mydb";

$ SQL。=" select * from mytbl;" ;;


$ result = mysql_query（$ SQL）;


i。即我想连接两个语句并仅执行一次查询

。


有没有办法用mysql_query（或其他函数）执行此操作？


谢谢......

In my PHP code, I want to execute the following two commands:

use mydb;
select * from mytbl;

Now, I can get it work with the following statements:

$SQL = "use mydb";
$result = mysql_query($SQL );

$SQL = "select * from mytbl";
$result = mysql_query($SQL );

What I really wan to do is "something" like:

$SQL = "use mydb ";
$SQL .= "select * from mytbl;";

$result = mysql_query($SQL );

i. e. I want to concatenate the two statement and execute the query only
once.

Is there a way to do this with mysql_query (or with someother function)?

Thanks...

推荐答案

SQL =" use mydb";

SQL = "use mydb";

result = mysql_query（

result = mysql_query(

SQL）;

SQL );

这篇关于多个命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！