Select * from emp;

; is know as delimiter it indicates end of command

DELIMITER //
Select * from emp //
Select sal * 0.2 from emp //
DELIMITER ;

MySQL - PL

• MySQL programming language
• Programming language of MySQL
• Used for database programming
• Example: HRA_CALC, TAX_CALC, ATTENDANCE_CALC etc
• Used for server side data processing
• Every RDBMS has its own native programming
• Language
  • Oracle → PL/SQL → Procedural language
  • MySQL → MySQL-PL → MySQL Programming Language
  • MS SQL Server → T-SQL → Transact SQL
• root > call hra_calc();

• Can be called in MySQL command line client, MySQL workbench, phpMyAdmin, Oracle forms, Oracle Reports, Oracle menus, Oracle Graphics, Java, MS .NET etc. MySQL-PL program can be called through any front end software.
• Has a few 4 GL features
• MySQL-PL program is commonly referred to as a MySQL-PL block

Begin
...;
insert into dept values (1, 'a', 'B');
...;
End;

• Block within a block is know as block level language. (4095 block limit)