Utility commands

• SHOW
• USE
• DESCRIBE OR DESC
• EXPLAIN
• DELIMITER
• EXPLAIN PLAN

SHOW

SHOW databases;
 
SHOW PROCEDURE STATUS;

USE

USE biblioteca;

DESCRIBE OR DESC

DECRIBE Persona;
 
DESC Persona;

EXPLAIN

EXPLAIN SELECT * FROM mytable WHERE id = 1;

DELIMITER

DELIMITER $$