写了个代码
<?php mysql_query("source sql", $link); ?>
结果死活 sql 的 SQL 语句就是没效果,查了下。
SOURCE is definitely a command that is preprocessed by the mysql client. The server does not understand that command. So you can't execute SOURCE on the server using the query API.
If you can restrict the content of your SQL script to exclude mysql client builtin commands, it might work to use mysqli::multi_query(). But it won't work for the full set of commands that are allowed in an SQL script.
爪子下,下次不要犯这么弱智的错误。