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 $
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
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
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
1, the file delimiter under Linux is '/', and the file delimiter under Windows is ' \ '. But the ' \ ' symbol is an escape character. If you need to output the ' \ ' symbol in the console, you need to enter ' \ \ '. In addition, the escape character
A new feature has been introduced in the Hive0.11.0 version that allows users to specify the delimiter for a column when the user outputs the hive query results to a file, whereas the previous version is not a separator between columns.Before Hive0.1
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 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.