Basic Content of MySQL 5.0

The following content mainly introduces the basic content of MySQL 5.0. at the same time, this article also lists the actual application code in MySQL 5.0. I hope you will understand the actual content of MySQL 5.0 after browsing. The following is the detailed description of the article.

 
 

  
  
CREATE PROCEDURE 
 
 

Create a table stored in the MySQL5.0 database.

 
 

  
  
CREATE FUNCTION 
 
 

Create a user-defined function, especially the stored procedure of the returned data.

 
 

  
  
ALTER PROCEDURE 
 
 

Change the pre-specified stored PROCEDURE created with create procedure without affecting the stored PROCEDURE or function ..

 
 

  
  
ALTER FUNCTION 
 
 

Change the pre-specified stored procedure created using the create function without affecting the stored procedure or FUNCTION ..

 
 

  
  
DROP PROCEDURE 
 
 

Delete one or more stored procedures from the MySQL 5.0 table.

 
 

  
  
DROP FUNCTION 
 
 

Delete one or more storage functions from the MySQL table.

 
 

  
  
SHOW CREATE PROCEDURE 
 
 

Returns the text of a pre-specified stored PROCEDURE created using create procedure. This statement is an SQL: 2003 Standard MySQL extension.

 
 

  
  
SHOW CREATE FUNCTION 
 
 

Returns the pre-specified Stored Procedure text created using the create function. This statement is an SQL: 2003 Standard MySQL 5.0 extension.

 
 

  
  
SHOW PROCEDURE STATUS 
 
 

Returns the features of a pre-specified stored procedure, including the name, type, creator, creation date, and change date. This statement is an SQL: 2003 Standard MySQL extension.

 
 

  
  
SHOW FUNCTION STATUS 
 
 

Returns the features of a pre-specified storage function, including name, type, creator, creation date, and change date. This statement is an SQL: 2003 Standard MySQL extension.

 
 

  
  
CALL 
 
 

Call a pre-specified stored PROCEDURE created using create procedure.

 
 

  
  
BEGIN ... END 
 
 

Contains multiple declarations executed by a group.

 
 

  
  
DECLARE 
 
 

It is used to specify local variables, environments, processors, and pointers.

 
 

  
  
SET 
 
 

Used to change the value of local and global server variables.

 
 

  
  
SELECT ... INTO 
 
 

Used to store the column of the DISPLAY variable.

 
 

  
  
OPEN 
 
 

Used to open a pointer.

 
 

  
  
FETCH 
 
 

Use a specific pointer to obtain the next column.

CLOSE

Used to close and open pointers.

IF

An if-then-else-end if statement.

CASE... WHEN

Structure of a case statement

LOOP

A simple loop structure; you can use the LEAVE statement to exit.

LEAVE

Used to exit the IF, CASE, LOOP, REPEAT, and WHILE statements.

ITERATE

Used to re-start the loop.

REPEAT

The test cycle at the end.

WHILE

Testing cycle at the beginning.

RETURNS

Returns the value of a stored procedure.

MySQL5.0 supports stored procedure statements.