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 vote177 views1 answer
Repeatable read trong sql server
SQL
0 vote167 views1 answer
How to avoid duplicate records in sqlite
SQL
2 votes171 views1 answer
Oracle kill session by sql_id
SQL
0 vote173 views1 answer
Mysql check datetime equals date
SQL
8 votes172 views3 answers
Postgres connection string
SQL
0 vote183 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote170 views1 answer
Call function sql oracle
SQL
3 votes186 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
20 votes191 views3 answers
Update values in select statement sql
SQL
11 votes184 views1 answer
Sql insert multiple rows from select
SQL