php数据库多次点击无效,从PHP运行多个MySQL查询|为什么这不起作用？

您只在查询一个.阅读mysql_query的文档

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.

$query1 = "TRUNCATE TABLE db2.table1;";

$query2 = "INSERT INTO db2.table1

SELECT

column1, column2, column3, column4

FROM db1.table1;";

$query3 = "TRUNCATE TABLE db2.table2;";

$query4 = "INSERT INTO db2.table2

SELECT

column1, column2, column3, column4

FROM db1.table2;";

$query5= "ANALYZE TABLE db2.table2;";

$result1 = @mysql_query($query1);

$result2 = @mysql_query($query2);

$result3 = @mysql_query($query3);

$result4 = @mysql_query($query4);

$result5 = @mysql_query($query5);

或使用其他支持多个查询的接口功能.我个人不知道是否有这样的事情.