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
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
What is the role of delimiter in MySQL?
This command has nothing to do with the stored procedure.In fact, 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
In fact, tell the MySQL tutorial interpreter, whether the command is over, whether MySQL can be executed.By default, delimiter is a semicolon;. In a command-line client, if a line of commands ends with a semicolon,Then, after the carriage return,
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.