After MySQL exports one sql:
DELIMITER $$
DROP TRIGGER IF EXISTS ' Updateegopriceondelete ' $$
CREATE
TRIGGER ' Updateegopriceondelete ' after the DELETE on ' CustomerInfo '
For each ROW BEGIN
DELETE from Egoprice WHERE
The following article is mainly to describe what is the role of delimiter in MySQL database? We generally think that this command is not related to stored procedures, is this the case? The following articles will give you the relevant knowledge,
After MYSQL exports an SQL statement:
DELIMITER $
Drop trigger if exists 'updateegopriceondelete' $
CREATE
TRIGGER 'updateegopriceondelete' after delete on 'mermerinfo'
FOR EACH ROW BEGIN
Delete from egoprice WHERE customerId = OLD. customerId;
END $
What is the role of delimiter in MySQL?This command doesn't have anything to do with stored procedures.In fact, just tell the MySQL interpreter if the command is over and MySQL can execute it.By default, delimiter is a semicolon;。 In the
This command doesn't have anything to do with stored procedures.In fact, just tell the MySQL interpreter if the command is over and MySQL can execute it.By default, delimiter is a semicolon;。 In the command-line client, if a single line of commands
Source: workshop?
It is to tell the MySQL interpreter whether the command has ended and whether MySQL can be executed.By default, Delimiter is a semicolon;. In the command line client, if a command line ends with a semicolon,After you press enter,
This command doesn't have anything to do with stored procedures.In fact, just tell the MySQL interpreter if the command is over and MySQL can execute it.By default, delimiter is a semicolon;。 In the command-line client, if a single line of commands
Take a closer look at the role of delimiter in MySql. what is the role of delimiter in MySql? Many may have such doubts. The following describes the role of delimiter in MySql for your reference.
After MYSQL exports an SQL statement:
What is the role of delimiter in MySql? Many may have such doubts. The following describes the role of delimiter in MySql for your reference.
After MYSQL exports an SQL statement:
DELIMITER $$
The following articles mainly describe the role of delimiter In the MySQL database? We generally think that this command has little to do with the stored procedure. Is it true? The following articles will give you relevant knowledge and I hope you
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.