MySQueaL Resources

Related SQL Statements

Below are MySQL statements related to the SQL topic selected.

BEGIN...END

Use this combination of MySQL statements to start and end the steps that are part of a stored procedure or trigger.

CALL

Use this MySQL statement to call a stored procedure.

CLOSE

This MySQL statement closes a cursor that has been declared within the current routine and has been opened using the OPEN statement.

DECLARE

This MySQL statement declares local variables and other items related to routines.

DELIMITER

This MySQL statement changes the delimiter (terminating character) of SQL statements from the default of a semi-colon to another character.

DROP PREPARE

This MySQL statement deletes a prepared statement.

EXECUTE

This MySQL statement executes a user-defined prepared statement.

FETCH

A cursor is similar to a MySQL table or a view: it represents, within a procedure, a results set that is retrieved one row at a time using this MySQL statement.

OPEN

This MySQL statement opens a cursor that has been declared within the current routine.

PREPARE

This MySQL statement creates a prepared statement.

Event Statements

ALTER EVENT

Use this MySQL statement to alter an existing scheduled MySQL event.

CREATE EVENT

Use this MySQL statement to schedule the execution of an SQL statement at a specific time and date.

DROP EVENT

This MySQL statement deletes an event.

SHOW CREATE EVENT

This MySQL statement displays an SQL statement that can be used to create an event like the one given.

SHOW EVENTS

This MySQL statement displays a list of scheduled events on the server.

User Function Statements

ALTER FUNCTION

This MySQL statement changes the characteristics of an existing user-defined function.

CREATE FUNCTION

A user-defined function is in essence a set of MySQL statements that may be called as a unit, processing any data it's given in its parameters and returning a value to the caller of the function.

DROP FUNCTION

Use this MySQL statement to delete a user-defined function.

SHOW CREATE FUNCTION

This MySQL statement displays an SQL statement that can be used to create a function like the one given.

SHOW FUNCTION CODE

This MySQL statement displays the internal code of a function.

SHOW FUNCTION STATUS

This MySQL statement displays information on user-defined functions.

Stored Procedures Statements

ALTER PROCEDURE

This MySQL statement changes the characteristics of an existing stored procedure.

CREATE PROCEDURE

A procedure, also known as a stored procedure, is set of MySQL statements stored on the MySQL server and called as a unit, processing any data it's given in its parameters.

DROP PROCEDURE

This MySQL statement deletes a stored procedure.

SHOW CREATE PROCEDURE

This MySQL statement displays an SQL statement that can be used to create a stored procedure like the one given.

SHOW PROCEDURE CODE

This MySQL statement displays the internal code of a stored procedure.

SHOW PROCEDURE STATUS

This MySQL statement displays information on stored procedures.

Trigger Statements

ALTER TRIGGER

There is not an ALTER TRIGGER statement in MySQL at this time.

CREATE TRIGGER

Triggers are actions to be taken when a user requests a change to data in MySQL.

DROP TRIGGER

This MySQL statement deletes a trigger.

SHOW TRIGGERS

This MySQL statement displays a list of triggers on the server.