What is delimiter in mysql

/*

Delimiters other than the default ; are typically used when defining functions, stored procedures, and triggers wherein you must define multiple statements. You define a different delimiter like $$ which is used to define the end of the entire procedure, but inside it, individual statements are each terminated by ;. That way, when the code is run in the mysql client, the client can tell where the entire procedure ends and execute it as a unit rather than executing the individual statements inside.

Note that the DELIMITER keyword is a function of the command line mysql client (and some other clients) only and not a regular MySQL language feature. It won't work if you tried to pass it through a programming language API to MySQL. Some other clients like PHPMyAdmin have other methods to specify a non-default delimiter.

*/

/* Example:*/

DELIMITER $$
/* This is a complete statement, not part of the procedure, so use the custom delimiter $$ */
DROP PROCEDURE my_procedure$$

/* Now start the procedure code */
CREATE PROCEDURE my_procedure ()
BEGIN    
  /* Inside the procedure, individual statements terminate with ; */
  CREATE TABLE tablea (
     col1 INT,
     col2 INT
  );

  INSERT INTO tablea
    SELECT * FROM table1;

  CREATE TABLE tableb (
     col1 INT,
     col2 INT
  );
  INSERT INTO tableb
    SELECT * FROM table2;
  
/* whole procedure ends with the custom delimiter */
END$$

/* Finally, reset the delimiter to the default ; */
DELIMITER ;

Source: stackoverflow.com

Similar codes

0 vote128 views1 answer
Change role postgres
SQL
1 vote139 views1 answer
Alter database datafile maxsize 32g
SQL
2 votes129 views1 answer
How to check grants on a package in oracle
SQL
1 vote169 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
1 vote125 views1 answer
Mysql remove last empty newline
SQL
0 vote118 views1 answer
Get number of rows in every table mysql
SQL
1 vote186 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote120 views1 answer
Raiserror nowait sql server
SQL
3 votes124 views2 answers
Tsql join multiple record in one string
SQL
6 votes127 views3 answers
Mysql first day of year
SQL