mysql udemy

readme.md

Notes

https://www.udemy.com/mysql-and-sql-from-beginner-to-advanced

Delimeter

delimiter will change what is used to terminate statements

  delimiter $$
  select * from books$$

Create procedure

create procedure helloWorld()
begin
<sql>
end

Drop procedure

drop procedure helloWorld

To Edit a procedure, drop and recreate it.

Call procedure

call helloWorld();