Question

I have huge problem (for me)

我需要执行PHP的MySQL指令DELIMITER <>code>,但mysql_query(有误。我发现,mysql_query(>n t support the use of DEMITER,因为这一指挥只在MySQL console工作。



但是,当我打开了phpMyAdmin时,可以选择将DELIMITER改变在Kingk及其运作,但我不知道如何。

Is it possible to change delimiter from PHP? I need it to do before calling a CREATE TRIGGER command that uses several ;.

Answer 1


也许,don t需要修改定义。

限制在CLCS中是必需的,以便了解KQ号声明的结尾之处,因为CLI将不断阅读和执行更多的声明,直到你告诉它停止(例如,有exit或控制-D)。 但是,它实际上的行文只是个性流;它需要说明一个声明何时结束和下一个开始。 这符合定义者所做的。

In PHP, each function call executes one statement. There can t be multiple statements in one function call, so there is no need for a way to delimit them. The statement is the entire string. This is true of the old mysql_query as well as the newer mysqli_query and PDO. Of course, there is mysqli_multi_query if you really want to pass multiple queries to one function.

在存储程序/触发/功能/etc的情况下,可以有多种说明,但由MySQL自己处理(总有<代码>;,AFAIK)。就购买力平价而言,这仍然是一份声明。

限制你在phpMyAdmin看到的情况,可能被用来分裂发言,而且很可能在《公共卫生法》中这样做。它必须这样做,因为它接受用户的投入,包括多种发言,但只能通过每个职能电话一次发言。 (我已经检查了《加拿大刑法》,以完全确保这一点。)

Answer 2

It depends. I use MySQLi s multi_query() function and leave ; as is when doing a procedure creating, actually done (PHP 5.6 & MySQL 5.6). I think you do not need care delimiter, leave the target code only then might work. You might try to query SQL only as

CREATE XXXX
BEGIN
    sth;
END

也有尝试。

Answer 3

you need a stored routine (procedure, function) to include all the necessary queries,
so in PHP, you can call the stored routine elegantly

友情链接